/*Process ACS Summary File Standard Error (SE) File Sequence 001*/ 
   /*Please add libname and modify INFILE statement before running SAS program */
     
TITLE "s20071co0001000";
DATA census.SFs001co;   
     
   LENGTH FILEID $6
          FILETYPE $6  
          STUSAB $2
		  CHARITER $3
		  SEQUENCE $4
		  LOGRECNO $7;
     
   INFILE 'C:\s20071co0001000.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'  

         /*SEX OF WORKERS BY MEANS OF TRANSPORTATION TO WORK FOR WORKPLACE GEOGRAPHY*/
         /*Universe:  Workers 16 years and over*/

         B08406001s='Total (SE)'
         B08406002s='    Car, truck, or van: (SE)'
         B08406003s='      Drove alone (SE)'
         B08406004s='      Carpooled: (SE)'
         B08406005s='        In 2-person carpool (SE)'
         B08406006s='        In 3-person carpool (SE)'
         B08406007s='        In 4-or-more-person carpool (SE)'
         B08406008s='    Public transportation (excluding taxicab): (SE)'
         B08406009s='      Bus or trolley bus (SE)'
         B08406010s='      Streetcar or trolley car (carro publico in Puerto Rico) (SE)'
         B08406011s='      Subway or elevated (SE)'
         B08406012s='      Railroad (SE)'
         B08406013s='      Ferryboat (SE)'
         B08406014s='    Bicycle (SE)'
         B08406015s='    Walked (SE)'
         B08406016s='    Taxicab, motorcycle, or other means (SE)'
         B08406017s='    Worked at home (SE)'
         B08406018s='  Male: (SE)'
         B08406019s='    Car, truck, or van: (SE)'
         B08406020s='      Drove alone (SE)'
         B08406021s='      Carpooled: (SE)'
         B08406022s='        In 2-person carpool (SE)'
         B08406023s='        In 3-person carpool (SE)'
         B08406024s='        In 4-or-more-person carpool (SE)'
         B08406025s='    Public transportation (excluding taxicab): (SE)'
         B08406026s='      Bus or trolley bus (SE)'
         B08406027s='      Streetcar or trolley car (carro publico in Puerto Rico) (SE)'
         B08406028s='      Subway or elevated (SE)'
         B08406029s='      Railroad (SE)'
         B08406030s='      Ferryboat (SE)'
         B08406031s='    Bicycle (SE)'
         B08406032s='    Walked (SE)'
         B08406033s='    Taxicab, motorcycle, or other means (SE)'
         B08406034s='    Worked at home (SE)'
         B08406035s='  Female: (SE)'
         B08406036s='    Car, truck, or van: (SE)'
         B08406037s='      Drove alone (SE)'
         B08406038s='      Carpooled: (SE)'
         B08406039s='        In 2-person carpool (SE)'
         B08406040s='        In 3-person carpool (SE)'
         B08406041s='        In 4-or-more-person carpool (SE)'
         B08406042s='    Public transportation (excluding taxicab): (SE)'
         B08406043s='      Bus or trolley bus (SE)'
         B08406044s='      Streetcar or trolley car (carro publico in Puerto Rico) (SE)'
         B08406045s='      Subway or elevated (SE)'
         B08406046s='      Railroad (SE)'
         B08406047s='      Ferryboat (SE)'
         B08406048s='    Bicycle (SE)'
         B08406049s='    Walked (SE)'
         B08406050s='    Taxicab, motorcycle, or other means (SE)'
         B08406051s='    Worked at home (SE)'
     
         /*SEX OF WORKERS BY TRAVEL TIME TO WORK FOR WORKPLACE GEOGRAPHY*/         
         /*Universe:  Workers 16 years and over who did not work at home*/

         B08412001s='Total: (SE)'
         B08412002s='    Less than 5 minutes (SE)'
         B08412003s='    5 to 9 minutes (SE)'  
         B08412004s='    10 to 14 minutes (SE)' 
         B08412005s='    15 to 19 minutes (SE)' 
         B08412006s='    20 to 24 minutes (SE)' 
         B08412007s='    25 to 29 minutes (SE)' 
         B08412008s='    30 to 34 minutes (SE)' 
         B08412009s='    35 to 39 minutes (SE)' 
         B08412010s='    40 to 44 minutes (SE)' 
         B08412011s='    45 to 59 minutes (SE)' 
         B08412012s='    60 to 89 minutes (SE)' 
         B08412013s='    90 or more minutes (SE)' 
         B08412014s='  Male: (SE)' 
         B08412015s='    Less than 5 minutes (SE)'
         B08412016s='    5 to 9 minutes (SE)' 
         B08412017s='    10 to 14 minutes (SE)' 
         B08412018s='    15 to 19 minutes (SE)' 
         B08412019s='    20 to 24 minutes (SE)' 
         B08412020s='    25 to 29 minutes (SE)' 
         B08412021s='    30 to 34 minutes (SE)' 
         B08412022s='    35 to 39 minutes (SE)' 
         B08412023s='    40 to 44 minutes (SE)' 
         B08412024s='    45 to 59 minutes (SE)' 
         B08412025s='    60 to 89 minutes (SE)' 
         B08412026s='    90 or more minutes (SE)' 
         B08412027s='  Female: (SE)' 
         B08412028s='    Less than 5 minutes (SE)'
         B08412029s='    5 to 9 minutes (SE)' 
         B08412030s='    10 to 14 minutes (SE)' 
         B08412031s='    15 to 19 minutes (SE)' 
         B08412032s='    20 to 24 minutes (SE)' 
         B08412033s='    25 to 29 minutes (SE)' 
         B08412034s='    30 to 34 minutes (SE)' 
         B08412035s='    35 to 39 minutes (SE)' 
         B08412036s='    40 to 44 minutes (SE)' 
         B08412037s='    45 to 59 minutes (SE)' 
         B08412038s='    60 to 89 minutes (SE)' 
         B08412039s='    90 or more minutes (SE)' 

         /*MEANS OF TRANSPORTATION TO WORK BY CITIZENSHIP STATUS FOR WORKPLACE GEOGRAPHY*/
         /*Universe:  Workers 16 years and over*/ 

         B08511001s='Total: (SE)'
         B08511002s='    Native (SE)'
         B08511003s='    Foreign born: (SE)'  
		 B08511004s='      Naturalized U.S. citizen (SE)' 
     	 B08511005s='      Not a U.S. citizen (SE)' 
		 B08511006s='  Car, truck, or van - drove alone: (SE)' 
		 B08511007s='    Native (SE)' 
		 B08511008s='    Foreign born: (SE)' 
		 B08511009s='      Naturalized U.S. citizen (SE)' 
		 B08511010s='      Not a U.S. citizen (SE)' 
		 B08511011s='  Car, truck, or van - carpooled: (SE)' 
		 B08511012s='    Native (SE)' 
		 B08511013s='    Foreign born: (SE)' 
		 B08511014s='      Naturalized U.S. citizen (SE)' 
		 B08511015s='      Not a U.S. citizen (SE)' 
		 B08511016s='  Public transportation (excluding taxicab): (SE)' 
		 B08511017s='    Native (SE)'
		 B08511018s='    Foreign born: (SE)' 
		 B08511019s='      Naturalized U.S. citizen (SE)' 
		 B08511020s='      Not a U.S. citizen (SE)' 
		 B08511021s='  Walked: (SE)' 
		 B08511022s='    Native (SE)'
		 B08511023s='    Foreign born: (SE)' 
		 B08511024s='      Naturalized U.S. citizen (SE)' 
		 B08511025s='      Not a U.S. citizen (SE)' 
		 B08511026s='  Taxicab, motorcycle, bicycle, or other means: (SE)' 
		 B08511027s='    Native (SE)'
		 B08511028s='    Foreign born: (SE)' 
		 B08511029s='      Naturalized U.S. citizen (SE)' 
		 B08511030s='      Not a U.S. citizen (SE)' 
		 B08511031s='  Worked at home: (SE)' 
		 B08511032s='    Native (SE)'
		 B08511033s='    Foreign born: (SE)' 
		 B08511034s='      Naturalized U.S. citizen (SE)' 
		 B08511035s='      Not a U.S. citizen (SE)' 

         /*SEX OF WORKERS BY MEANS OF TRANSPORTATION TO WORK FOR WORKPLACE GEOGRAPHY*/
         /*Universe:  Workers 16 years and over*/

         C08406001s='Total: (SE)'
		 C08406002s='    Car, truck, or van: (SE)'
		 C08406003s='      Drove alone (SE)'  
		 C08406004s='      Carpooled: (SE)'  
		 C08406005s='        In 2-person carpool (SE)' 
		 C08406006s='        In 3-person carpool (SE)'  
		 C08406007s='        In 4-or-more-person carpool (SE)' 
		 C08406008s='    Public transportation (excluding taxicab) (SE)' 
		 C08406009s='    Walked (SE)' 
		 C08406010s='    Taxicab, motorcycle, bicycle, or other means (SE)' 
		 C08406011s='    Worked at home (SE)' 
		 C08406012s='  Male: (SE)' 
		 C08406013s='    Car, truck, or van: (SE)' 
		 C08406014s='      Drove alone (SE)' 
		 C08406015s='      Carpooled: (SE)' 
		 C08406016s='        In 2-person carpool (SE)' 
		 C08406017s='        In 3-person carpool (SE)' 
		 C08406018s='        In 4-or-more-person carpool (SE)' 
		 C08406019s='    Public transportation (excluding taxicab) (SE)' 
		 C08406020s='    Walked (SE)' 
		 C08406021s='    Taxicab, motorcycle, bicycle, or other means (SE)' 
		 C08406022s='    Worked at home (SE)' 
		 C08406023s='  Female: (SE)' 
		 C08406024s='    Car, truck, or van: (SE)' 
		 C08406025s='      Drove alone (SE)' 
		 C08406026s='      Carpooled: (SE)' 
		 C08406027s='        In 2-person carpool (SE)' 
		 C08406028s='        In 3-person carpool (SE)' 
		 C08406029s='        In 4-or-more-person carpool (SE)' 
		 C08406030s='    Public transportation (excluding taxicab) (SE)' 
		 C08406031s='    Walked (SE)' 
		 C08406032s='    Taxicab, motorcycle, bicycle, or other means (SE)' 
		 C08406033s='    Worked at home (SE)' 

		 /*SEX OF WORKERS BY TRAVEL TIME TO WORK FOR WORKPLACE GEOGRAPHY*/
		 /*Universe:  Workers 16 years and over who did not work at home*/ 

		 C08412001s='Total: (SE)'
		 C08412002s='    Less than 10 minutes (SE)'
		 C08412003s='    10 to 14 minutes (SE)' 
		 C08412004s='    15 to 19 minutes (SE)' 
		 C08412005s='    20 to 24 minutes (SE)' 
		 C08412006s='    25 to 29 minutes (SE)' 
		 C08412007s='    30 to 34 minutes (SE)'  
		 C08412008s='    35 to 44 minutes (SE)' 
		 C08412009s='    45 to 59 minutes (SE)' 
		 C08412010s='    60 or more minutes (SE)' 
		 C08412011s='  Male: (SE)'
		 C08412012s='    Less than 10 minutes (SE)'
		 C08412013s='    10 to 14 minutes (SE)' 
		 C08412014s='    15 to 19 minutes (SE)' 
		 C08412015s='    20 to 24 minutes (SE)' 
		 C08412016s='    25 to 29 minutes (SE)' 
		 C08412017s='    30 to 34 minutes (SE)' 
		 C08412018s='    35 to 44 minutes (SE)' 
		 C08412019s='    45 to 59 minutes (SE)' 
		 C08412020s='    60 or more minutes (SE)' 
		 C08412021s='  Female: (SE)'
		 C08412022s='    Less than 10 minutes (SE)'
		 C08412023s='    10 to 14 minutes (SE)' 
		 C08412024s='    15 to 19 minutes (SE)' 
		 C08412025s='    20 to 24 minutes (SE)' 
		 C08412026s='    25 to 29 minutes (SE)' 
		 C08412027s='    30 to 34 minutes (SE)' 
		 C08412028s='    35 to 44 minutes (SE)' 
		 C08412029s='    45 to 59 minutes (SE)' 
		 C08412030s='    60 or more minutes (SE)' 

		 /*MEANS OF TRANSPORTATION TO WORK BY CITIZENSHIP STATUS FOR WORKPLACE GEOGRAPHY*/
		 /*Universe:  Workers 16 years and over*/ 

		 C08511001s='Total: (SE)'
		 C08511002s='    Native (SE)'
		 C08511003s='    Foreign born: (SE)' 
		 C08511004s='      Naturalized U.S. citizen (SE)' 
		 C08511005s='      Not a U.S. citizen (SE)' 
		 C08511006s='  Car, truck, or van - drove alone: (SE)' 
		 C08511007s='    Native (SE)'
		 C08511008s='    Foreign born: (SE)' 
		 C08511009s='      Naturalized U.S. citizen (SE)' 
		 C08511010s='      Not a U.S. citizen (SE)' 
		 C08511011s='  Car, truck, or van - carpooled: (SE)' 
		 C08511012s='    Native (SE)'
		 C08511013s='    Foreign born: (SE)' 
		 C08511014s='      Naturalized U.S. citizen (SE)' 
		 C08511015s='      Not a U.S. citizen (SE)' 
		 C08511016s='  Public transportation (excluding taxicab): (SE)' 
		 C08511017s='    Native (SE)'
		 C08511018s='    Foreign born: (SE)' 
		 C08511019s='      Naturalized U.S. citizen (SE)' 
		 C08511020s='      Not a U.S. citizen (SE)' 
		 C08511021s='  Taxicab, motorcycle, bicycle, walked, or other means: (SE)' 
		 C08511022s='    Native (SE)'
		 C08511023s='    Foreign born: (SE)' 
		 C08511024s='      Naturalized U.S. citizen (SE)' 
		 C08511025s='      Not a U.S. citizen (SE)' 
		 C08511026s='  Worked at home: (SE)' 
		 C08511027s='    Native (SE)'
		 C08511028s='    Foreign born: (SE)' 
		 C08511029s='      Naturalized U.S. citizen (SE)' 
		 C08511030s='      Not a U.S. citizen (SE)'; 
     
   INPUT
     
         FILEID $
         FILETYPE $  
         STUSAB $
		 CHARITER $
		 SEQUENCE $
		 LOGRECNO $
         B08406001s
         B08406002s
         B08406003s
         B08406004s
         B08406005s
         B08406006s
         B08406007s
         B08406008s
         B08406009s
         B08406010s
         B08406011s
         B08406012s
         B08406013s
         B08406014s
         B08406015s
         B08406016s
         B08406017s
         B08406018s
         B08406019s
         B08406020s
         B08406021s
         B08406022s
         B08406023s
         B08406024s
         B08406025s
         B08406026s
         B08406027s
         B08406028s
         B08406029s
         B08406030s
         B08406031s
         B08406032s
         B08406033s
         B08406034s
         B08406035s
         B08406036s
         B08406037s
         B08406038s
         B08406039s
         B08406040s
         B08406041s
         B08406042s
         B08406043s
         B08406044s
         B08406045s
         B08406046s
         B08406047s
         B08406048s
         B08406049s
         B08406050s
         B08406051s
     
         B08412001s
         B08412002s
         B08412003s
         B08412004s
         B08412005s
         B08412006s
         B08412007s
         B08412008s
         B08412009s
         B08412010s
         B08412011s
         B08412012s
         B08412013s
         B08412014s
         B08412015s
         B08412016s
         B08412017s
         B08412018s
         B08412019s
         B08412020s
         B08412021s
         B08412022s
         B08412023s
         B08412024s
         B08412025s
         B08412026s
         B08412027s
         B08412028s
         B08412029s
         B08412030s
         B08412031s
         B08412032s
         B08412033s
         B08412034s
         B08412035s
         B08412036s
         B08412037s
         B08412038s
         B08412039s

         B08511001s
         B08511002s
         B08511003s
		 B08511004s
     	 B08511005s
		 B08511006s
		 B08511007s
		 B08511008s
		 B08511009s
		 B08511010s
		 B08511011s
		 B08511012s
		 B08511013s
		 B08511014s
		 B08511015s
		 B08511016s
		 B08511017s
		 B08511018s
		 B08511019s
		 B08511020s
		 B08511021s
		 B08511022s
		 B08511023s
		 B08511024s
		 B08511025s
		 B08511026s
		 B08511027s
		 B08511028s
		 B08511029s
		 B08511030s
		 B08511031s
		 B08511032s
		 B08511033s
		 B08511034s
		 B08511035s

         C08406001s
		 C08406002s
		 C08406003s
		 C08406004s
		 C08406005s
		 C08406006s
		 C08406007s
		 C08406008s
		 C08406009s
		 C08406010s
		 C08406011s
		 C08406012s
		 C08406013s
		 C08406014s
		 C08406015s
		 C08406016s
		 C08406017s
		 C08406018s
		 C08406019s
		 C08406020s
		 C08406021s
		 C08406022s
		 C08406023s
		 C08406024s
		 C08406025s
		 C08406026s
		 C08406027s
		 C08406028s
		 C08406029s
		 C08406030s
		 C08406031s
		 C08406032s
		 C08406033s

		 C08412001s
		 C08412002s
		 C08412003s
		 C08412004s
		 C08412005s
		 C08412006s
		 C08412007s
		 C08412008s
		 C08412009s
		 C08412010s
		 C08412011s
		 C08412012s
		 C08412013s
		 C08412014s
		 C08412015s
		 C08412016s
		 C08412017s
		 C08412018s
		 C08412019s
		 C08412020s
		 C08412021s
		 C08412022s
		 C08412023s
		 C08412024s
		 C08412025s
		 C08412026s
		 C08412027s
		 C08412028s
		 C08412029s
		 C08412030s

		 C08511001s
		 C08511002s
		 C08511003s
		 C08511004s
		 C08511005s
		 C08511006s
		 C08511007s
		 C08511008s
		 C08511009s
		 C08511010s
		 C08511011s
		 C08511012s
		 C08511013s
		 C08511014s
		 C08511015s
		 C08511016s
		 C08511017s
		 C08511018s
		 C08511019s
		 C08511020s
		 C08511021s
		 C08511022s
		 C08511023s
		 C08511024s
		 C08511025s
		 C08511026s
		 C08511027s
		 C08511028s
		 C08511029s
		 C08511030s;

RUN;