TITLE "m20081ak0001000";
DATA work.SFm0001ak;
 
	LENGTH FILEID $6
		   FILETYPE $6
		   STUSAB $2
		   CHARITER $3
		   SEQUENCE $4
		   LOGRECNO $7;
 
INFILE '<Your Home Directory>m20081ak0001000.txt' DSD TRUNCOVER DELIMITER =',' LRECL=3072;
 
LABEL FILEID='File Identification'
      FILETYPE='File Type'  
 	   STUSAB='State/U.S.-Abbreviation (USPS)'
 	   CHARITER='Character Iteration'
 	   SEQUENCE='Sequence Number'
 	   LOGRECNO='Logical Record Number'
 
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY AGE FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Population 1 year and over in the United States */
 
B07401m1='Total living in area 1 year ago:'
B07401m2='1 to 4 years'
B07401m3='5 to 17 years'
B07401m4='18 and 19 years'
B07401m5='20 to 24 years'
B07401m6='25 to 29 years'
B07401m7='30 to 34 years'
B07401m8='35 to 39 years'
B07401m9='40 to 44 years'
B07401m10='45 to 49 years'
B07401m11='50 to 54 years'
B07401m12='55 to 59 years'
B07401m13='60 to 64 years'
B07401m14='65 to 69 years'
B07401m15='70 to 74 years'
B07401m16='75 years and over'
B07401m17='Same house:'
B07401m18='1 to 4 years'
B07401m19='5 to 17 years'
B07401m20='18 and 19 years'
B07401m21='20 to 24 years'
B07401m22='25 to 29 years'
B07401m23='30 to 34 years'
B07401m24='35 to 39 years'
B07401m25='40 to 44 years'
B07401m26='45 to 49 years'
B07401m27='50 to 54 years'
B07401m28='55 to 59 years'
B07401m29='60 to 64 years'
B07401m30='65 to 69 years'
B07401m31='70 to 74 years'
B07401m32='75 years and over'
B07401m33='Moved within same county:'
B07401m34='1 to 4 years'
B07401m35='5 to 17 years'
B07401m36='18 and 19 years'
B07401m37='20 to 24 years'
B07401m38='25 to 29 years'
B07401m39='30 to 34 years'
B07401m40='35 to 39 years'
B07401m41='40 to 44 years'
B07401m42='45 to 49 years'
B07401m43='50 to 54 years'
B07401m44='55 to 59 years'
B07401m45='60 to 64 years'
B07401m46='65 to 69 years'
B07401m47='70 to 74 years'
B07401m48='75 years and over'
B07401m49='Moved to different county within same state:'
B07401m50='1 to 4 years'
B07401m51='5 to 17 years'
B07401m52='18 and 19 years'
B07401m53='20 to 24 years'
B07401m54='25 to 29 years'
B07401m55='30 to 34 years'
B07401m56='35 to 39 years'
B07401m57='40 to 44 years'
B07401m58='45 to 49 years'
B07401m59='50 to 54 years'
B07401m60='55 to 59 years'
B07401m61='60 to 64 years'
B07401m62='65 to 69 years'
B07401m63='70 to 74 years'
B07401m64='75 years and over'
B07401m65='Moved to different state:'
B07401m66='1 to 4 years'
B07401m67='5 to 17 years'
B07401m68='18 and 19 years'
B07401m69='20 to 24 years'
B07401m70='25 to 29 years'
B07401m71='30 to 34 years'
B07401m72='35 to 39 years'
B07401m73='40 to 44 years'
B07401m74='45 to 49 years'
B07401m75='50 to 54 years'
B07401m76='55 to 59 years'
B07401m77='60 to 64 years'
B07401m78='65 to 69 years'
B07401m79='70 to 74 years'
B07401m80='75 years and over'
 
/*MEDIAN AGE BY GEOGRAPHICAL MOBILITY IN THE PAST YEAR FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Population 1 year and over in the United States */
/*Median age -- */
 
B07402m1='Total living in area 1 year ago:'
B07402m2='Same house'
B07402m3='Moved within same county'
B07402m4='Moved to different county within same state'
B07402m5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY SEX FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Population 1 year and over in the United States */
 
B07403m1='Total living in area 1 year ago:'
B07403m2='Male'
B07403m3='Female'
B07403m4='Same house:'
B07403m5='Male'
B07403m6='Female'
B07403m7='Moved within same county:'
B07403m8='Male'
B07403m9='Female'
B07403m10='Moved to different county within same state:'
B07403m11='Male'
B07403m12='Female'
B07403m13='Moved to different state:'
B07403m14='Male'
B07403m15='Female'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (WHITE ALONE) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  White alone population 1 year and over in the United States */
 
B07404Am1='Total living in area 1 year ago:'
B07404Am2='Same house'
B07404Am3='Moved within same county'
B07404Am4='Moved to different county within same state'
B07404Am5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (BLACK OR AFRICAN AMERICAN ALONE) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Black or African American alone population 1 year and over in the United States */
 
B07404Bm1='Total living in area 1 year ago:'
B07404Bm2='Same house'
B07404Bm3='Moved within same county'
B07404Bm4='Moved to different county within same state'
B07404Bm5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (AMERICAN INDIAN AND ALASKA NATIVE ALONE) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  American Indian and Alaska Native alone population 1 year and over in the United States */
 
B07404Cm1='Total living in area 1 year ago:'
B07404Cm2='Same house'
B07404Cm3='Moved within same county'
B07404Cm4='Moved to different county within same state'
B07404Cm5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (ASIAN ALONE) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Asian alone population 1 year and over in the United States */
 
B07404Dm1='Total living in area 1 year ago:'
B07404Dm2='Same house'
B07404Dm3='Moved within same county'
B07404Dm4='Moved to different county within same state'
B07404Dm5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Native Hawaiian and Other Pacific Islander alone population 1 year and over in the United States */
 
B07404Em1='Total living in area 1 year ago:'
B07404Em2='Same house'
B07404Em3='Moved within same county'
B07404Em4='Moved to different county within same state'
B07404Em5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (SOME OTHER RACE ALONE) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Some other race alone population 1 year and over in the United States */
 
B07404Fm1='Total living in area 1 year ago:'
B07404Fm2='Same house'
B07404Fm3='Moved within same county'
B07404Fm4='Moved to different county within same state'
B07404Fm5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (TWO OR MORE RACES) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Two or more races population 1 year and over in the United States */
 
B07404Gm1='Total living in area 1 year ago:'
B07404Gm2='Same house'
B07404Gm3='Moved within same county'
B07404Gm4='Moved to different county within same state'
B07404Gm5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (WHITE ALONE, NOT HISPANIC OR LATINO) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  White alone, not Hispanic or Latino population 1 year and over in the United States */
 
B07404Hm1='Total living in area 1 year ago:'
B07404Hm2='Same house'
B07404Hm3='Moved within same county'
B07404Hm4='Moved to different county within same state'
B07404Hm5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY RACE (HISPANIC OR LATINO) FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Hispanic or Latino population 1 year and over in the United States */
 
B07404Im1='Total living in area 1 year ago:'
B07404Im2='Same house'
B07404Im3='Moved within same county'
B07404Im4='Moved to different county within same state'
B07404Im5='Moved to different state'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY CITIZENSHIP STATUS FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe:  Population 1 year and over in the United States */
 
B07407m1='Total living in area 1 year ago:'
B07407m2='Native'
B07407m3='Foreign born:'
B07407m4='Naturalized U.S. citizen'
B07407m5='Not a U.S. citizen'
B07407m6='Same house:'
B07407m7='Native'
B07407m8='Foreign born:'
B07407m9='Naturalized U.S. citizen'
B07407m10='Not a U.S. citizen'
B07407m11='Moved within same county:'
B07407m12='Native'
B07407m13='Foreign born:'
B07407m14='Naturalized U.S. citizen'
B07407m15='Not a U.S. citizen'
B07407m16='Moved to different county within same state:'
B07407m17='Native'
B07407m18='Foreign born:'
B07407m19='Naturalized U.S. citizen'
B07407m20='Not a U.S. citizen'
B07407m21='Moved to different state:'
B07407m22='Native'
B07407m23='Foreign born:'
B07407m24='Naturalized U.S. citizen'
B07407m25='Not a U.S. citizen'
 
/*GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY AGE FOR RESIDENCE 1 YEAR AGO IN THE UNITED STATES */
/*Universe: Population 1 year and over in the United States */
 
C07401m1='Total living in area 1 year ago:'
C07401m2='1 to 4 years'
C07401m3='5 to 17 years'
C07401m4='18 to 24 years'
C07401m5='25 to 34 years'
C07401m6='35 to 44 years'
C07401m7='45 to 54 years'
C07401m8='55 to 64 years'
C07401m9='65 to 74 years'
C07401m10='75 years and over'
C07401m11='Same house:'
C07401m12='1 to 4 years'
C07401m13='5 to 17 years'
C07401m14='18 to 24 years'
C07401m15='25 to 34 years'
C07401m16='35 to 44 years'
C07401m17='45 to 54 years'
C07401m18='55 to 64 years'
C07401m19='65 to 74 years'
C07401m20='75 years and over'
C07401m21='Moved within same county:'
C07401m22='1 to 4 years'
C07401m23='5 to 17 years'
C07401m24='18 to 24 years'
C07401m25='25 to 34 years'
C07401m26='35 to 44 years'
C07401m27='45 to 54 years'
C07401m28='55 to 64 years'
C07401m29='65 to 74 years'
C07401m30='75 years and over'
C07401m31='Moved to different county within same state:'
C07401m32='1 to 4 years'
C07401m33='5 to 17 years'
C07401m34='18 to 24 years'
C07401m35='25 to 34 years'
C07401m36='35 to 44 years'
C07401m37='45 to 54 years'
C07401m38='55 to 64 years'
C07401m39='65 to 74 years'
C07401m40='75 years and over'
C07401m41='Moved to different state:'
C07401m42='1 to 4 years'
C07401m43='5 to 17 years'
C07401m44='18 to 24 years'
C07401m45='25 to 34 years'
C07401m46='35 to 44 years'
C07401m47='45 to 54 years'
C07401m48='55 to 64 years'
C07401m49='65 to 74 years'
C07401m50='75 years and over'
;
 
 
INPUT
 
 
FILEID $ 
FILETYPE $ 
STUSAB $ 
CHARITER $ 
SEQUENCE $ 
LOGRECNO $ 
 
B07401m1
B07401m2
B07401m3
B07401m4
B07401m5
B07401m6
B07401m7
B07401m8
B07401m9
B07401m10
B07401m11
B07401m12
B07401m13
B07401m14
B07401m15
B07401m16
B07401m17
B07401m18
B07401m19
B07401m20
B07401m21
B07401m22
B07401m23
B07401m24
B07401m25
B07401m26
B07401m27
B07401m28
B07401m29
B07401m30
B07401m31
B07401m32
B07401m33
B07401m34
B07401m35
B07401m36
B07401m37
B07401m38
B07401m39
B07401m40
B07401m41
B07401m42
B07401m43
B07401m44
B07401m45
B07401m46
B07401m47
B07401m48
B07401m49
B07401m50
B07401m51
B07401m52
B07401m53
B07401m54
B07401m55
B07401m56
B07401m57
B07401m58
B07401m59
B07401m60
B07401m61
B07401m62
B07401m63
B07401m64
B07401m65
B07401m66
B07401m67
B07401m68
B07401m69
B07401m70
B07401m71
B07401m72
B07401m73
B07401m74
B07401m75
B07401m76
B07401m77
B07401m78
B07401m79
B07401m80
 
B07402m1
B07402m2
B07402m3
B07402m4
B07402m5
 
B07403m1
B07403m2
B07403m3
B07403m4
B07403m5
B07403m6
B07403m7
B07403m8
B07403m9
B07403m10
B07403m11
B07403m12
B07403m13
B07403m14
B07403m15
 
B07404Am1
B07404Am2
B07404Am3
B07404Am4
B07404Am5
 
B07404Bm1
B07404Bm2
B07404Bm3
B07404Bm4
B07404Bm5
 
B07404Cm1
B07404Cm2
B07404Cm3
B07404Cm4
B07404Cm5
 
B07404Dm1
B07404Dm2
B07404Dm3
B07404Dm4
B07404Dm5
 
B07404Em1
B07404Em2
B07404Em3
B07404Em4
B07404Em5
 
B07404Fm1
B07404Fm2
B07404Fm3
B07404Fm4
B07404Fm5
 
B07404Gm1
B07404Gm2
B07404Gm3
B07404Gm4
B07404Gm5
 
B07404Hm1
B07404Hm2
B07404Hm3
B07404Hm4
B07404Hm5
 
B07404Im1
B07404Im2
B07404Im3
B07404Im4
B07404Im5
 
B07407m1
B07407m2
B07407m3
B07407m4
B07407m5
B07407m6
B07407m7
B07407m8
B07407m9
B07407m10
B07407m11
B07407m12
B07407m13
B07407m14
B07407m15
B07407m16
B07407m17
B07407m18
B07407m19
B07407m20
B07407m21
B07407m22
B07407m23
B07407m24
B07407m25
 
C07401m1
C07401m2
C07401m3
C07401m4
C07401m5
C07401m6
C07401m7
C07401m8
C07401m9
C07401m10
C07401m11
C07401m12
C07401m13
C07401m14
C07401m15
C07401m16
C07401m17
C07401m18
C07401m19
C07401m20
C07401m21
C07401m22
C07401m23
C07401m24
C07401m25
C07401m26
C07401m27
C07401m28
C07401m29
C07401m30
C07401m31
C07401m32
C07401m33
C07401m34
C07401m35
C07401m36
C07401m37
C07401m38
C07401m39
C07401m40
C07401m41
C07401m42
C07401m43
C07401m44
C07401m45
C07401m46
C07401m47
C07401m48
C07401m49
C07401m50
;
RUN;