************************************************************************************************* ; * THIS IS AN EXAMPLE OF A PROGRAM THAT CAN BE USED TO READ IN THE * ; * LINKED WFL-CMS SSA (FINAL) FEASIBILITY STUDY ASCII FILE. * ; * * ; * TO DOWNLOAD AND SAVE THE LINKED WFL-SSA (FINAL) FEASIBILITY STUDY * ; * ASCII FILE TO YOUR HARD DRIVE, FOLLOW THESE STEPS: * ; * * ; * STEP 1: DESIGNATE A FOLDER ON YOUR HARD DRIVE TO DOWNLOAD THE LINKED * ; * WFL-SSA FEASIBILITY STUDY ASCII FILE. IN THIS EXAMPLE * ; * THE DATA WILL BE SAVED TO: 'C:\Feasibility Study Data\' * ; * * ; * STEP 2: DOWNLOAD THE ASCII DATA FROM THE WFL WEB SITE. * ; * GO TO THE WFL WEB SITE AND DOWNLOAD THE LINKED * ; * WFL-SSA (FINAL) FEASIBILITY STUDY ASCII FILE TO THE FOLDER * ; * 'C:\Feasibility Study Data\' * ; * * ; * * ; * * ; * * ; * IMPORTANT INFORMATION REGARDING THE SURVEY ID VARIABLE: * ; * * ; * FOR WFL USE PUBLICID AS THE ID VARIABLE * ; * FOR RUEC USE SEQN AS THE ID VARIABLE * ; * FOR RUWC USE RESNUM AS THE ID VARIABLE * ; * * ; ************************************************************************************************* ; filename intext "C:\Feasibility Study Data\SSA_FEASIBILITY_[survey name].dat" ; data Feasibility ; infile intext lrecl=20 ; input @1 PUBLICID $CHAR14. @1 SEQN 5. @1 RESNUM 7. /* FOR NNHS 1985 RESNUM SHOULD BE CREATED USING POSITIONS 1 - 7 */ @1 RESNUM 6. /* FOR NNHS 1995 1997 AND 2004 RESNUM SHOULD BE CREATED USING POSITIONS 1 - 6 */ @15 SSA_MATCH 1. @16 ON_MBR_FLAG 1. @17 ON_SSR_FLAG 1. @18 ON_PHUS_FLAG 1. @19 ON_831_FLAG 1. @20 ON_QOC_FLAG 1. ; attrib PUBLICID length=$14 label="WFL SURVEY ID NUMBER" SEQN length=5 label="SAMPLE SEQUENCE NUMBER (PUBLIC ID)" RESNUM length=7 label="WFL SURVEY IDENTIFIER - RESIDENT RECORD NUMBER" SSA_MATCH length=3 label="SSA MATCH STATUS" ON_MBR_FLAG length=3 label="ON MBR FILE INDICATOR" ON_SSR_FLAG length=3 label="ON SSR FILE INDICATOR" ON_PHUS_FLAG length=3 label="ON PHUS FILE INDICATOR" ON_831_FLAG length=3 label="ON 831 FILE INDICATOR" ON_QOC_FLAG length=3 label="ON QOC FILE INDICATOR"; run; proc contents data=Feasibility varnum ; run ; proc freq data=Feasibility (drop=PUBLICID SEQN RESNUM) ; tables _all_ /missing ; run ;