********************************************************************* PROGRAM NAME: CREATE_FORMATTED_FREQUENCIES.SAS THIS IS AN EXAMPLE OF A SAS PROGRAM THAT ATTACHES VARIABLE VALUE LABELS TO THE SAS DATA SETS. ATTACHING LABELS WILL ALLOW YOU TO PRODUCE FORMATTED OUTPUT LIKE THAT SEEN IN THE DETAILED VARIABLE CONTENT LISTING AND FREQUENCY REPORTS IN THE DOCUMENTATION. *********************************************************************; options ps = 80 ls = 155 nodate; /* standard portrait */ ** "PUF" REFERS TO THE DIRECTORY WHERE THE **; ** PERMANENT SAS DATASETS ARE CONTAINED **; LIBNAME PUF 'H:\Data\NSCH 2007\PUF01'; /* CHANGE DIRECTORY LOCATION TO WHERE YOU'VE SAVED THE DATA SET */ ** "library" REFERS TO THE DIRECTORY WHERE **; ** PERMANENT FORMATS ARE GOING TO BE STORED **; libname library 'H:\Data\NSCH 2007\PUF01'; /* CHANGE DIRECTORY LOCATION TO WHERE YOU'VE SAVED THE DATA SET */ %INCLUDE "H:\Data\NSCH 2007\PUF01\create_2007_nsch_formats.sas"; /* INPUT SAS PROGRAM THAT CREATES FORMATS */ DATA puf.nsch_2007_puf_formatted; SET puf.nsch_2007_puf; %INCLUDE "H:\Data\NSCH 2007\PUF01\attach_2007_nsch_formats.sas"; /* INPUT SAS PROGRAM THAT ATTACHES FORMATS */ run; PROC CONTENTS VARNUM; title1 "2007 NSCH"; title2 "Public Use File Variables"; RUN; PROC FREQ; TABLES STATE MSA_STAT TOTKIDS4 AGEPOS4 AGEYR_CHILD FLG_06_MNTH FLG_18_MNTH SEX RELATION PLANGUAGE K2Q01 K2Q01_D K2Q02R HGHT_FLG K2Q03R WGHT_FLG BMICLASS K2Q04R BWGHT_FLG K2Q10 K2Q11 K2Q12 K2Q13 K2Q14 K2Q15 K2Q16 K2Q17 K2Q18 K2Q19 K2Q20 K2Q21 K2Q22 K2Q23 CSHCN K2Q30A K2Q30B K2Q30C K2Q30D K2Q31A K2Q32A K2Q33A K2Q34A K2Q35A K2Q36A K2Q37A K2Q40A K2Q41A K2Q38A K2Q42A K2Q43A K2Q44A K2Q45A K2Q46A K2Q31B K2Q31C K2Q31D K2Q32B K2Q32C K2Q33B K2Q33C K2Q34B K2Q34C K2Q35B K2Q35C K2Q36B K2Q36C K2Q37B K2Q37C K2Q40B K2Q40C K2Q41B K2Q41C K2Q38B K2Q38C K2Q42B K2Q42C K2Q43B K2Q43C K2Q44B K2Q44C K2Q45B K2Q45C K2Q45DX01 K2Q45DX02 K2Q45DX03 K2Q46B K2Q46C K2Q47A K2Q48A K2Q49A K2Q50A K2Q51A K2Q47C K2Q48C K2Q49C K2Q50C K2Q51C K2Q52 K2Q53 K2Q54 K2Q55 K2Q60A K2Q60B K2Q60C K2Q61A K2Q61B K2Q61C K2Q81 K2Q82 K2Q83 K2Q84 K2Q85 K3Q01 K3Q02 K3Q03 K3Q04 K3Q20 K3Q22 K3Q21A K3Q21B K4Q01 K4Q02R K4Q04 K4Q20R K4Q21R K4Q22 K4Q23 K4Q24 K4Q25 K4Q26 K4Q27 K4Q28X01 K4Q28X02 K4Q28X03 K4Q28X04 K5Q10 K5Q11 K5Q20 K5Q21 K5Q22 K5Q30 K5Q31 K5Q32 K5Q40 K5Q41 K5Q42 K5Q43 K5Q44 K5Q45 K5Q46 K6Q01 K6Q02 K6Q03 K6Q04 K6Q05 K6Q06 K6Q07 K6Q08 K6Q09 K6Q10 K6Q11 K6Q12 K6Q13A K6Q13B K6Q14A K6Q14B K6Q15 K6Q20 K6Q20BX01 K6Q20BX02 K6Q20BX03 K6Q21 K6Q22 K6Q25A K6Q25B K6Q25C K6Q26 K6Q27 K6Q30 K6Q31X01 K6Q31X02 K6Q31X03 K6Q40 K6Q41R K6Q42R K6Q43R K6Q60 K6Q61 K6Q63 K6Q64 K6Q65 K6Q65A K7Q01 K7Q01F K7Q02R K7Q04R K7Q05 K7Q11 K7Q30 K7Q31 K7Q32 K7Q33 K7Q34 K7Q35 K7Q36 K7Q37 K7Q38 K7Q39 K7Q40 K7Q41 K7Q50 K7Q50A K7Q51 K7Q51A K7Q60 K7Q60A K7Q61 K7Q62 K7Q70 K7Q71 K7Q72 K7Q73 K7Q74 K7Q75 K7Q76 K7Q77 K7Q78 K7Q79 K7Q80 K7Q82 K7Q83 K8Q12R K8Q11 K8Q21 K8Q30 K8Q31 K8Q32 K8Q34 K8Q35 TOTADULT3 FAMSTRUCT K9Q16R MARCOH_PAR MARSTAT_PAR MARCOH_RESP MARSTAT_RESP K9Q18 K9Q20 K9Q21 K9Q22 K9Q23 K9Q24 K9Q25 K9Q30 K9Q31 K9Q32 K9Q40 K9Q41 K10Q11 K10Q12 K10Q13 K10Q14 K10Q20 K10Q22 K10Q23 K10Q30 K10Q31 K10Q32 K10Q34 K10Q40 K10Q41 HISPANIC RACER RACE_HI RACEASIA RACEAIAN K11Q03R EDUC_MOMR EDUC_DADR EDUC_RESR K11Q30 K11Q31 K11Q32 K11Q33 K11Q34AR K11Q35AR K11Q36AR K11Q37AR K11Q43R K11Q50 POVERTY_LEVELR K11Q60 K11Q61 K11Q62 OTH_LANG SUMMER / missing list; title1 "2007 NSCH"; title2 "Public Use File Formatted Frequencies"; run;