TITLE "e20081ak0001000";
DATA work.SFe0001ak;
 
	LENGTH FILEID $6
		   FILETYPE $6
		   STUSAB $2
		   CHARITER $3
		   SEQUENCE $4
		   LOGRECNO $7;
 
INFILE '<Your Home Directory>e20081ak0001000.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 */
 
B07401e1='Total living in area 1 year ago:'
B07401e2='1 to 4 years'
B07401e3='5 to 17 years'
B07401e4='18 and 19 years'
B07401e5='20 to 24 years'
B07401e6='25 to 29 years'
B07401e7='30 to 34 years'
B07401e8='35 to 39 years'
B07401e9='40 to 44 years'
B07401e10='45 to 49 years'
B07401e11='50 to 54 years'
B07401e12='55 to 59 years'
B07401e13='60 to 64 years'
B07401e14='65 to 69 years'
B07401e15='70 to 74 years'
B07401e16='75 years and over'
B07401e17='Same house:'
B07401e18='1 to 4 years'
B07401e19='5 to 17 years'
B07401e20='18 and 19 years'
B07401e21='20 to 24 years'
B07401e22='25 to 29 years'
B07401e23='30 to 34 years'
B07401e24='35 to 39 years'
B07401e25='40 to 44 years'
B07401e26='45 to 49 years'
B07401e27='50 to 54 years'
B07401e28='55 to 59 years'
B07401e29='60 to 64 years'
B07401e30='65 to 69 years'
B07401e31='70 to 74 years'
B07401e32='75 years and over'
B07401e33='Moved within same county:'
B07401e34='1 to 4 years'
B07401e35='5 to 17 years'
B07401e36='18 and 19 years'
B07401e37='20 to 24 years'
B07401e38='25 to 29 years'
B07401e39='30 to 34 years'
B07401e40='35 to 39 years'
B07401e41='40 to 44 years'
B07401e42='45 to 49 years'
B07401e43='50 to 54 years'
B07401e44='55 to 59 years'
B07401e45='60 to 64 years'
B07401e46='65 to 69 years'
B07401e47='70 to 74 years'
B07401e48='75 years and over'
B07401e49='Moved to different county within same state:'
B07401e50='1 to 4 years'
B07401e51='5 to 17 years'
B07401e52='18 and 19 years'
B07401e53='20 to 24 years'
B07401e54='25 to 29 years'
B07401e55='30 to 34 years'
B07401e56='35 to 39 years'
B07401e57='40 to 44 years'
B07401e58='45 to 49 years'
B07401e59='50 to 54 years'
B07401e60='55 to 59 years'
B07401e61='60 to 64 years'
B07401e62='65 to 69 years'
B07401e63='70 to 74 years'
B07401e64='75 years and over'
B07401e65='Moved to different state:'
B07401e66='1 to 4 years'
B07401e67='5 to 17 years'
B07401e68='18 and 19 years'
B07401e69='20 to 24 years'
B07401e70='25 to 29 years'
B07401e71='30 to 34 years'
B07401e72='35 to 39 years'
B07401e73='40 to 44 years'
B07401e74='45 to 49 years'
B07401e75='50 to 54 years'
B07401e76='55 to 59 years'
B07401e77='60 to 64 years'
B07401e78='65 to 69 years'
B07401e79='70 to 74 years'
B07401e80='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 -- */
 
B07402e1='Total living in area 1 year ago:'
B07402e2='Same house'
B07402e3='Moved within same county'
B07402e4='Moved to different county within same state'
B07402e5='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 */
 
B07403e1='Total living in area 1 year ago:'
B07403e2='Male'
B07403e3='Female'
B07403e4='Same house:'
B07403e5='Male'
B07403e6='Female'
B07403e7='Moved within same county:'
B07403e8='Male'
B07403e9='Female'
B07403e10='Moved to different county within same state:'
B07403e11='Male'
B07403e12='Female'
B07403e13='Moved to different state:'
B07403e14='Male'
B07403e15='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 */
 
B07404Ae1='Total living in area 1 year ago:'
B07404Ae2='Same house'
B07404Ae3='Moved within same county'
B07404Ae4='Moved to different county within same state'
B07404Ae5='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 */
 
B07404Be1='Total living in area 1 year ago:'
B07404Be2='Same house'
B07404Be3='Moved within same county'
B07404Be4='Moved to different county within same state'
B07404Be5='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 */
 
B07404Ce1='Total living in area 1 year ago:'
B07404Ce2='Same house'
B07404Ce3='Moved within same county'
B07404Ce4='Moved to different county within same state'
B07404Ce5='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 */
 
B07404De1='Total living in area 1 year ago:'
B07404De2='Same house'
B07404De3='Moved within same county'
B07404De4='Moved to different county within same state'
B07404De5='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 */
 
B07404Ee1='Total living in area 1 year ago:'
B07404Ee2='Same house'
B07404Ee3='Moved within same county'
B07404Ee4='Moved to different county within same state'
B07404Ee5='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 */
 
B07404Fe1='Total living in area 1 year ago:'
B07404Fe2='Same house'
B07404Fe3='Moved within same county'
B07404Fe4='Moved to different county within same state'
B07404Fe5='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 */
 
B07404Ge1='Total living in area 1 year ago:'
B07404Ge2='Same house'
B07404Ge3='Moved within same county'
B07404Ge4='Moved to different county within same state'
B07404Ge5='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 */
 
B07404He1='Total living in area 1 year ago:'
B07404He2='Same house'
B07404He3='Moved within same county'
B07404He4='Moved to different county within same state'
B07404He5='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 */
 
B07404Ie1='Total living in area 1 year ago:'
B07404Ie2='Same house'
B07404Ie3='Moved within same county'
B07404Ie4='Moved to different county within same state'
B07404Ie5='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 */
 
B07407e1='Total living in area 1 year ago:'
B07407e2='Native'
B07407e3='Foreign born:'
B07407e4='Naturalized U.S. citizen'
B07407e5='Not a U.S. citizen'
B07407e6='Same house:'
B07407e7='Native'
B07407e8='Foreign born:'
B07407e9='Naturalized U.S. citizen'
B07407e10='Not a U.S. citizen'
B07407e11='Moved within same county:'
B07407e12='Native'
B07407e13='Foreign born:'
B07407e14='Naturalized U.S. citizen'
B07407e15='Not a U.S. citizen'
B07407e16='Moved to different county within same state:'
B07407e17='Native'
B07407e18='Foreign born:'
B07407e19='Naturalized U.S. citizen'
B07407e20='Not a U.S. citizen'
B07407e21='Moved to different state:'
B07407e22='Native'
B07407e23='Foreign born:'
B07407e24='Naturalized U.S. citizen'
B07407e25='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 */
 
C07401e1='Total living in area 1 year ago:'
C07401e2='1 to 4 years'
C07401e3='5 to 17 years'
C07401e4='18 to 24 years'
C07401e5='25 to 34 years'
C07401e6='35 to 44 years'
C07401e7='45 to 54 years'
C07401e8='55 to 64 years'
C07401e9='65 to 74 years'
C07401e10='75 years and over'
C07401e11='Same house:'
C07401e12='1 to 4 years'
C07401e13='5 to 17 years'
C07401e14='18 to 24 years'
C07401e15='25 to 34 years'
C07401e16='35 to 44 years'
C07401e17='45 to 54 years'
C07401e18='55 to 64 years'
C07401e19='65 to 74 years'
C07401e20='75 years and over'
C07401e21='Moved within same county:'
C07401e22='1 to 4 years'
C07401e23='5 to 17 years'
C07401e24='18 to 24 years'
C07401e25='25 to 34 years'
C07401e26='35 to 44 years'
C07401e27='45 to 54 years'
C07401e28='55 to 64 years'
C07401e29='65 to 74 years'
C07401e30='75 years and over'
C07401e31='Moved to different county within same state:'
C07401e32='1 to 4 years'
C07401e33='5 to 17 years'
C07401e34='18 to 24 years'
C07401e35='25 to 34 years'
C07401e36='35 to 44 years'
C07401e37='45 to 54 years'
C07401e38='55 to 64 years'
C07401e39='65 to 74 years'
C07401e40='75 years and over'
C07401e41='Moved to different state:'
C07401e42='1 to 4 years'
C07401e43='5 to 17 years'
C07401e44='18 to 24 years'
C07401e45='25 to 34 years'
C07401e46='35 to 44 years'
C07401e47='45 to 54 years'
C07401e48='55 to 64 years'
C07401e49='65 to 74 years'
C07401e50='75 years and over'
;
 
 
INPUT
 
 
FILEID $ 
FILETYPE $ 
STUSAB $ 
CHARITER $ 
SEQUENCE $ 
LOGRECNO $ 
 
B07401e1
B07401e2
B07401e3
B07401e4
B07401e5
B07401e6
B07401e7
B07401e8
B07401e9
B07401e10
B07401e11
B07401e12
B07401e13
B07401e14
B07401e15
B07401e16
B07401e17
B07401e18
B07401e19
B07401e20
B07401e21
B07401e22
B07401e23
B07401e24
B07401e25
B07401e26
B07401e27
B07401e28
B07401e29
B07401e30
B07401e31
B07401e32
B07401e33
B07401e34
B07401e35
B07401e36
B07401e37
B07401e38
B07401e39
B07401e40
B07401e41
B07401e42
B07401e43
B07401e44
B07401e45
B07401e46
B07401e47
B07401e48
B07401e49
B07401e50
B07401e51
B07401e52
B07401e53
B07401e54
B07401e55
B07401e56
B07401e57
B07401e58
B07401e59
B07401e60
B07401e61
B07401e62
B07401e63
B07401e64
B07401e65
B07401e66
B07401e67
B07401e68
B07401e69
B07401e70
B07401e71
B07401e72
B07401e73
B07401e74
B07401e75
B07401e76
B07401e77
B07401e78
B07401e79
B07401e80
 
B07402e1
B07402e2
B07402e3
B07402e4
B07402e5
 
B07403e1
B07403e2
B07403e3
B07403e4
B07403e5
B07403e6
B07403e7
B07403e8
B07403e9
B07403e10
B07403e11
B07403e12
B07403e13
B07403e14
B07403e15
 
B07404Ae1
B07404Ae2
B07404Ae3
B07404Ae4
B07404Ae5
 
B07404Be1
B07404Be2
B07404Be3
B07404Be4
B07404Be5
 
B07404Ce1
B07404Ce2
B07404Ce3
B07404Ce4
B07404Ce5
 
B07404De1
B07404De2
B07404De3
B07404De4
B07404De5
 
B07404Ee1
B07404Ee2
B07404Ee3
B07404Ee4
B07404Ee5
 
B07404Fe1
B07404Fe2
B07404Fe3
B07404Fe4
B07404Fe5
 
B07404Ge1
B07404Ge2
B07404Ge3
B07404Ge4
B07404Ge5
 
B07404He1
B07404He2
B07404He3
B07404He4
B07404He5
 
B07404Ie1
B07404Ie2
B07404Ie3
B07404Ie4
B07404Ie5
 
B07407e1
B07407e2
B07407e3
B07407e4
B07407e5
B07407e6
B07407e7
B07407e8
B07407e9
B07407e10
B07407e11
B07407e12
B07407e13
B07407e14
B07407e15
B07407e16
B07407e17
B07407e18
B07407e19
B07407e20
B07407e21
B07407e22
B07407e23
B07407e24
B07407e25
 
C07401e1
C07401e2
C07401e3
C07401e4
C07401e5
C07401e6
C07401e7
C07401e8
C07401e9
C07401e10
C07401e11
C07401e12
C07401e13
C07401e14
C07401e15
C07401e16
C07401e17
C07401e18
C07401e19
C07401e20
C07401e21
C07401e22
C07401e23
C07401e24
C07401e25
C07401e26
C07401e27
C07401e28
C07401e29
C07401e30
C07401e31
C07401e32
C07401e33
C07401e34
C07401e35
C07401e36
C07401e37
C07401e38
C07401e39
C07401e40
C07401e41
C07401e42
C07401e43
C07401e44
C07401e45
C07401e46
C07401e47
C07401e48
C07401e49
C07401e50
;
RUN;