TITLE "s20081ak0001000";
DATA work.SFs0001ak;
 
	LENGTH FILEID $6
		   FILETYPE $6
		   STUSAB $2
		   CHARITER $3
		   SEQUENCE $4
		   LOGRECNO $7;
 
INFILE '/tab4/sumfile/prod/2008/data/s20081ak0001000.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 */
 
B07401s1='Total living in area 1 year ago:'
B07401s2='1 to 4 years'
B07401s3='5 to 17 years'
B07401s4='18 and 19 years'
B07401s5='20 to 24 years'
B07401s6='25 to 29 years'
B07401s7='30 to 34 years'
B07401s8='35 to 39 years'
B07401s9='40 to 44 years'
B07401s10='45 to 49 years'
B07401s11='50 to 54 years'
B07401s12='55 to 59 years'
B07401s13='60 to 64 years'
B07401s14='65 to 69 years'
B07401s15='70 to 74 years'
B07401s16='75 years and over'
B07401s17='Same house:'
B07401s18='1 to 4 years'
B07401s19='5 to 17 years'
B07401s20='18 and 19 years'
B07401s21='20 to 24 years'
B07401s22='25 to 29 years'
B07401s23='30 to 34 years'
B07401s24='35 to 39 years'
B07401s25='40 to 44 years'
B07401s26='45 to 49 years'
B07401s27='50 to 54 years'
B07401s28='55 to 59 years'
B07401s29='60 to 64 years'
B07401s30='65 to 69 years'
B07401s31='70 to 74 years'
B07401s32='75 years and over'
B07401s33='Moved within same county:'
B07401s34='1 to 4 years'
B07401s35='5 to 17 years'
B07401s36='18 and 19 years'
B07401s37='20 to 24 years'
B07401s38='25 to 29 years'
B07401s39='30 to 34 years'
B07401s40='35 to 39 years'
B07401s41='40 to 44 years'
B07401s42='45 to 49 years'
B07401s43='50 to 54 years'
B07401s44='55 to 59 years'
B07401s45='60 to 64 years'
B07401s46='65 to 69 years'
B07401s47='70 to 74 years'
B07401s48='75 years and over'
B07401s49='Moved to different county within same state:'
B07401s50='1 to 4 years'
B07401s51='5 to 17 years'
B07401s52='18 and 19 years'
B07401s53='20 to 24 years'
B07401s54='25 to 29 years'
B07401s55='30 to 34 years'
B07401s56='35 to 39 years'
B07401s57='40 to 44 years'
B07401s58='45 to 49 years'
B07401s59='50 to 54 years'
B07401s60='55 to 59 years'
B07401s61='60 to 64 years'
B07401s62='65 to 69 years'
B07401s63='70 to 74 years'
B07401s64='75 years and over'
B07401s65='Moved to different state:'
B07401s66='1 to 4 years'
B07401s67='5 to 17 years'
B07401s68='18 and 19 years'
B07401s69='20 to 24 years'
B07401s70='25 to 29 years'
B07401s71='30 to 34 years'
B07401s72='35 to 39 years'
B07401s73='40 to 44 years'
B07401s74='45 to 49 years'
B07401s75='50 to 54 years'
B07401s76='55 to 59 years'
B07401s77='60 to 64 years'
B07401s78='65 to 69 years'
B07401s79='70 to 74 years'
B07401s80='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 -- */
 
B07402s1='Total living in area 1 year ago:'
B07402s2='Same house'
B07402s3='Moved within same county'
B07402s4='Moved to different county within same state'
B07402s5='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 */
 
B07403s1='Total living in area 1 year ago:'
B07403s2='Male'
B07403s3='Female'
B07403s4='Same house:'
B07403s5='Male'
B07403s6='Female'
B07403s7='Moved within same county:'
B07403s8='Male'
B07403s9='Female'
B07403s10='Moved to different county within same state:'
B07403s11='Male'
B07403s12='Female'
B07403s13='Moved to different state:'
B07403s14='Male'
B07403s15='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 */
 
B07404As1='Total living in area 1 year ago:'
B07404As2='Same house'
B07404As3='Moved within same county'
B07404As4='Moved to different county within same state'
B07404As5='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 */
 
B07404Bs1='Total living in area 1 year ago:'
B07404Bs2='Same house'
B07404Bs3='Moved within same county'
B07404Bs4='Moved to different county within same state'
B07404Bs5='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 */
 
B07404Cs1='Total living in area 1 year ago:'
B07404Cs2='Same house'
B07404Cs3='Moved within same county'
B07404Cs4='Moved to different county within same state'
B07404Cs5='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 */
 
B07404Ds1='Total living in area 1 year ago:'
B07404Ds2='Same house'
B07404Ds3='Moved within same county'
B07404Ds4='Moved to different county within same state'
B07404Ds5='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 */
 
B07404Es1='Total living in area 1 year ago:'
B07404Es2='Same house'
B07404Es3='Moved within same county'
B07404Es4='Moved to different county within same state'
B07404Es5='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 */
 
B07404Fs1='Total living in area 1 year ago:'
B07404Fs2='Same house'
B07404Fs3='Moved within same county'
B07404Fs4='Moved to different county within same state'
B07404Fs5='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 */
 
B07404Gs1='Total living in area 1 year ago:'
B07404Gs2='Same house'
B07404Gs3='Moved within same county'
B07404Gs4='Moved to different county within same state'
B07404Gs5='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 */
 
B07404Hs1='Total living in area 1 year ago:'
B07404Hs2='Same house'
B07404Hs3='Moved within same county'
B07404Hs4='Moved to different county within same state'
B07404Hs5='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 */
 
B07404Is1='Total living in area 1 year ago:'
B07404Is2='Same house'
B07404Is3='Moved within same county'
B07404Is4='Moved to different county within same state'
B07404Is5='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 */
 
B07407s1='Total living in area 1 year ago:'
B07407s2='Native'
B07407s3='Foreign born:'
B07407s4='Naturalized U.S. citizen'
B07407s5='Not a U.S. citizen'
B07407s6='Same house:'
B07407s7='Native'
B07407s8='Foreign born:'
B07407s9='Naturalized U.S. citizen'
B07407s10='Not a U.S. citizen'
B07407s11='Moved within same county:'
B07407s12='Native'
B07407s13='Foreign born:'
B07407s14='Naturalized U.S. citizen'
B07407s15='Not a U.S. citizen'
B07407s16='Moved to different county within same state:'
B07407s17='Native'
B07407s18='Foreign born:'
B07407s19='Naturalized U.S. citizen'
B07407s20='Not a U.S. citizen'
B07407s21='Moved to different state:'
B07407s22='Native'
B07407s23='Foreign born:'
B07407s24='Naturalized U.S. citizen'
B07407s25='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 */
 
C07401s1='Total living in area 1 year ago:'
C07401s2='1 to 4 years'
C07401s3='5 to 17 years'
C07401s4='18 to 24 years'
C07401s5='25 to 34 years'
C07401s6='35 to 44 years'
C07401s7='45 to 54 years'
C07401s8='55 to 64 years'
C07401s9='65 to 74 years'
C07401s10='75 years and over'
C07401s11='Same house:'
C07401s12='1 to 4 years'
C07401s13='5 to 17 years'
C07401s14='18 to 24 years'
C07401s15='25 to 34 years'
C07401s16='35 to 44 years'
C07401s17='45 to 54 years'
C07401s18='55 to 64 years'
C07401s19='65 to 74 years'
C07401s20='75 years and over'
C07401s21='Moved within same county:'
C07401s22='1 to 4 years'
C07401s23='5 to 17 years'
C07401s24='18 to 24 years'
C07401s25='25 to 34 years'
C07401s26='35 to 44 years'
C07401s27='45 to 54 years'
C07401s28='55 to 64 years'
C07401s29='65 to 74 years'
C07401s30='75 years and over'
C07401s31='Moved to different county within same state:'
C07401s32='1 to 4 years'
C07401s33='5 to 17 years'
C07401s34='18 to 24 years'
C07401s35='25 to 34 years'
C07401s36='35 to 44 years'
C07401s37='45 to 54 years'
C07401s38='55 to 64 years'
C07401s39='65 to 74 years'
C07401s40='75 years and over'
C07401s41='Moved to different state:'
C07401s42='1 to 4 years'
C07401s43='5 to 17 years'
C07401s44='18 to 24 years'
C07401s45='25 to 34 years'
C07401s46='35 to 44 years'
C07401s47='45 to 54 years'
C07401s48='55 to 64 years'
C07401s49='65 to 74 years'
C07401s50='75 years and over'
;
 
 
INPUT
 
 
FILEID $ 
FILETYPE $ 
STUSAB $ 
CHARITER $ 
SEQUENCE $ 
LOGRECNO $ 
 
B07401s1
B07401s2
B07401s3
B07401s4
B07401s5
B07401s6
B07401s7
B07401s8
B07401s9
B07401s10
B07401s11
B07401s12
B07401s13
B07401s14
B07401s15
B07401s16
B07401s17
B07401s18
B07401s19
B07401s20
B07401s21
B07401s22
B07401s23
B07401s24
B07401s25
B07401s26
B07401s27
B07401s28
B07401s29
B07401s30
B07401s31
B07401s32
B07401s33
B07401s34
B07401s35
B07401s36
B07401s37
B07401s38
B07401s39
B07401s40
B07401s41
B07401s42
B07401s43
B07401s44
B07401s45
B07401s46
B07401s47
B07401s48
B07401s49
B07401s50
B07401s51
B07401s52
B07401s53
B07401s54
B07401s55
B07401s56
B07401s57
B07401s58
B07401s59
B07401s60
B07401s61
B07401s62
B07401s63
B07401s64
B07401s65
B07401s66
B07401s67
B07401s68
B07401s69
B07401s70
B07401s71
B07401s72
B07401s73
B07401s74
B07401s75
B07401s76
B07401s77
B07401s78
B07401s79
B07401s80
 
B07402s1
B07402s2
B07402s3
B07402s4
B07402s5
 
B07403s1
B07403s2
B07403s3
B07403s4
B07403s5
B07403s6
B07403s7
B07403s8
B07403s9
B07403s10
B07403s11
B07403s12
B07403s13
B07403s14
B07403s15
 
B07404As1
B07404As2
B07404As3
B07404As4
B07404As5
 
B07404Bs1
B07404Bs2
B07404Bs3
B07404Bs4
B07404Bs5
 
B07404Cs1
B07404Cs2
B07404Cs3
B07404Cs4
B07404Cs5
 
B07404Ds1
B07404Ds2
B07404Ds3
B07404Ds4
B07404Ds5
 
B07404Es1
B07404Es2
B07404Es3
B07404Es4
B07404Es5
 
B07404Fs1
B07404Fs2
B07404Fs3
B07404Fs4
B07404Fs5
 
B07404Gs1
B07404Gs2
B07404Gs3
B07404Gs4
B07404Gs5
 
B07404Hs1
B07404Hs2
B07404Hs3
B07404Hs4
B07404Hs5
 
B07404Is1
B07404Is2
B07404Is3
B07404Is4
B07404Is5
 
B07407s1
B07407s2
B07407s3
B07407s4
B07407s5
B07407s6
B07407s7
B07407s8
B07407s9
B07407s10
B07407s11
B07407s12
B07407s13
B07407s14
B07407s15
B07407s16
B07407s17
B07407s18
B07407s19
B07407s20
B07407s21
B07407s22
B07407s23
B07407s24
B07407s25
 
C07401s1
C07401s2
C07401s3
C07401s4
C07401s5
C07401s6
C07401s7
C07401s8
C07401s9
C07401s10
C07401s11
C07401s12
C07401s13
C07401s14
C07401s15
C07401s16
C07401s17
C07401s18
C07401s19
C07401s20
C07401s21
C07401s22
C07401s23
C07401s24
C07401s25
C07401s26
C07401s27
C07401s28
C07401s29
C07401s30
C07401s31
C07401s32
C07401s33
C07401s34
C07401s35
C07401s36
C07401s37
C07401s38
C07401s39
C07401s40
C07401s41
C07401s42
C07401s43
C07401s44
C07401s45
C07401s46
C07401s47
C07401s48
C07401s49
C07401s50
;
RUN;