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

         B08406001e='Total'
         B08406002e='    Car, truck, or van:'
         B08406003e='      Drove alone'
         B08406004e='      Carpooled:'
         B08406005e='        In 2-person carpool'
         B08406006e='        In 3-person carpool'
         B08406007e='        In 4-or-more-person carpool'
         B08406008e='    Public transportation (excluding taxicab):'
         B08406009e='      Bus or trolley bus'
         B08406010e='      Streetcar or trolley car (carro publico in Puerto Rico)'
         B08406011e='      Subway or elevated'
         B08406012e='      Railroad'
         B08406013e='      Ferryboat'
         B08406014e='    Bicycle'
         B08406015e='    Walked'
         B08406016e='    Taxicab, motorcycle, or other means'
         B08406017e='    Worked at home'
         B08406018e='  Male:'
         B08406019e='    Car, truck, or van:'
         B08406020e='      Drove alone'
         B08406021e='      Carpooled:'
         B08406022e='        In 2-person carpool'
         B08406023e='        In 3-person carpool'
         B08406024e='        In 4-or-more-person carpool'
         B08406025e='    Public transportation (excluding taxicab):'
         B08406026e='      Bus or trolley bus'
         B08406027e='      Streetcar or trolley car (carro publico in Puerto Rico)'
         B08406028e='      Subway or elevated'
         B08406029e='      Railroad'
         B08406030e='      Ferryboat'
         B08406031e='    Bicycle'
         B08406032e='    Walked'
         B08406033e='    Taxicab, motorcycle, or other means'
         B08406034e='    Worked at home'
         B08406035e='  Female:'
         B08406036e='    Car, truck, or van:'
         B08406037e='      Drove alone'
         B08406038e='      Carpooled:'
         B08406039e='        In 2-person carpool'
         B08406040e='        In 3-person carpool'
         B08406041e='        In 4-or-more-person carpool'
         B08406042e='    Public transportation (excluding taxicab):'
         B08406043e='      Bus or trolley bus'
         B08406044e='      Streetcar or trolley car (carro publico in Puerto Rico)'
         B08406045e='      Subway or elevated'
         B08406046e='      Railroad'
         B08406047e='      Ferryboat'
         B08406048e='    Bicycle'
         B08406049e='    Walked'
         B08406050e='    Taxicab, motorcycle, or other means'
         B08406051e='    Worked at home'
     
         /*SEX OF WORKERS BY TRAVEL TIME TO WORK FOR WORKPLACE GEOGRAPHY*/         
         /*Universe:  Workers 16 years and over who did not work at home*/

         B08412001e='Total:'
         B08412002e='    Less than 5 minutes'
         B08412003e='    5 to 9 minutes' 
         B08412004e='    10 to 14 minutes' 
         B08412005e='    15 to 19 minutes' 
         B08412006e='    20 to 24 minutes' 
         B08412007e='    25 to 29 minutes' 
         B08412008e='    30 to 34 minutes' 
         B08412009e='    35 to 39 minutes' 
         B08412010e='    40 to 44 minutes' 
         B08412011e='    45 to 59 minutes' 
         B08412012e='    60 to 89 minutes' 
         B08412013e='    90 or more minutes' 
         B08412014e='  Male:' 
         B08412015e='    Less than 5 minutes'
         B08412016e='    5 to 9 minutes' 
         B08412017e='    10 to 14 minutes' 
         B08412018e='    15 to 19 minutes' 
         B08412019e='    20 to 24 minutes' 
         B08412020e='    25 to 29 minutes' 
         B08412021e='    30 to 34 minutes' 
         B08412022e='    35 to 39 minutes' 
         B08412023e='    40 to 44 minutes' 
         B08412024e='    45 to 59 minutes' 
         B08412025e='    60 to 89 minutes' 
         B08412026e='    90 or more minutes' 
         B08412027e='  Female:' 
         B08412028e='    Less than 5 minutes'
         B08412029e='    5 to 9 minutes' 
         B08412030e='    10 to 14 minutes' 
         B08412031e='    15 to 19 minutes' 
         B08412032e='    20 to 24 minutes' 
         B08412033e='    25 to 29 minutes' 
         B08412034e='    30 to 34 minutes' 
         B08412035e='    35 to 39 minutes' 
         B08412036e='    40 to 44 minutes' 
         B08412037e='    45 to 59 minutes' 
         B08412038e='    60 to 89 minutes' 
         B08412039e='    90 or more minutes' 

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

         B08511001e='Total:'
         B08511002e='    Native'
         B08511003e='    Foreign born:' 
		 B08511004e='      Naturalized U.S. citizen' 
     	 B08511005e='      Not a U.S. citizen' 
		 B08511006e='  Car, truck, or van - drove alone:' 
		 B08511007e='    Native' 
		 B08511008e='    Foreign born:' 
		 B08511009e='      Naturalized U.S. citizen' 
		 B08511010e='      Not a U.S. citizen' 
		 B08511011e='  Car, truck, or van - carpooled:' 
		 B08511012e='    Native' 
		 B08511013e='    Foreign born:' 
		 B08511014e='      Naturalized U.S. citizen' 
		 B08511015e='      Not a U.S. citizen' 
		 B08511016e='  Public transportation (excluding taxicab):' 
		 B08511017e='    Native'
		 B08511018e='    Foreign born:' 
		 B08511019e='      Naturalized U.S. citizen' 
		 B08511020e='      Not a U.S. citizen' 
		 B08511021e='  Walked:' 
		 B08511022e='    Native'
		 B08511023e='    Foreign born:' 
		 B08511024e='      Naturalized U.S. citizen' 
		 B08511025e='      Not a U.S. citizen' 
		 B08511026e='  Taxicab, motorcycle, bicycle, or other means:' 
		 B08511027e='    Native'
		 B08511028e='    Foreign born:' 
		 B08511029e='      Naturalized U.S. citizen' 
		 B08511030e='      Not a U.S. citizen' 
		 B08511031e='  Worked at home:' 
		 B08511032e='    Native'
		 B08511033e='    Foreign born:' 
		 B08511034e='      Naturalized U.S. citizen' 
		 B08511035e='      Not a U.S. citizen' 

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

         C08406001e='Total:'
		 C08406002e='    Car, truck, or van:'
		 C08406003e='      Drove alone' 
		 C08406004e='      Carpooled:' 
		 C08406005e='        In 2-person carpool' 
		 C08406006e='        In 3-person carpool' 
		 C08406007e='        In 4-or-more-person carpool' 
		 C08406008e='    Public transportation (excluding taxicab)' 
		 C08406009e='    Walked' 
		 C08406010e='    Taxicab, motorcycle, bicycle, or other means' 
		 C08406011e='    Worked at home' 
		 C08406012e='  Male:' 
		 C08406013e='    Car, truck, or van:' 
		 C08406014e='      Drove alone' 
		 C08406015e='      Carpooled:' 
		 C08406016e='        In 2-person carpool' 
		 C08406017e='        In 3-person carpool' 
		 C08406018e='        In 4-or-more-person carpool' 
		 C08406019e='    Public transportation (excluding taxicab)' 
		 C08406020e='    Walked' 
		 C08406021e='    Taxicab, motorcycle, bicycle, or other means' 
		 C08406022e='    Worked at home' 
		 C08406023e='  Female:' 
		 C08406024e='    Car, truck, or van:' 
		 C08406025e='      Drove alone' 
		 C08406026e='      Carpooled:' 
		 C08406027e='        In 2-person carpool' 
		 C08406028e='        In 3-person carpool' 
		 C08406029e='        In 4-or-more-person carpool' 
		 C08406030e='    Public transportation (excluding taxicab)' 
		 C08406031e='    Walked' 
		 C08406032e='    Taxicab, motorcycle, bicycle, or other means' 
		 C08406033e='    Worked at home' 

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

		 C08412001e='Total:'
		 C08412002e='    Less than 10 minutes'
		 C08412003e='    10 to 14 minutes' 
		 C08412004e='    15 to 19 minutes' 
		 C08412005e='    20 to 24 minutes' 
		 C08412006e='    25 to 29 minutes' 
		 C08412007e='    30 to 34 minutes' 
		 C08412008e='    35 to 44 minutes' 
		 C08412009e='    45 to 59 minutes' 
		 C08412010e='    60 or more minutes' 
		 C08412011e='  Male:'
		 C08412012e='    Less than 10 minutes'
		 C08412013e='    10 to 14 minutes' 
		 C08412014e='    15 to 19 minutes' 
		 C08412015e='    20 to 24 minutes' 
		 C08412016e='    25 to 29 minutes' 
		 C08412017e='    30 to 34 minutes' 
		 C08412018e='    35 to 44 minutes' 
		 C08412019e='    45 to 59 minutes' 
		 C08412020e='    60 or more minutes' 
		 C08412021e='  Female:'
		 C08412022e='    Less than 10 minutes'
		 C08412023e='    10 to 14 minutes' 
		 C08412024e='    15 to 19 minutes' 
		 C08412025e='    20 to 24 minutes' 
		 C08412026e='    25 to 29 minutes' 
		 C08412027e='    30 to 34 minutes' 
		 C08412028e='    35 to 44 minutes' 
		 C08412029e='    45 to 59 minutes' 
		 C08412030e='    60 or more minutes' 

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

		 C08511001e='Total:'
		 C08511002e='    Native'
		 C08511003e='    Foreign born:' 
		 C08511004e='      Naturalized U.S. citizen' 
		 C08511005e='      Not a U.S. citizen' 
		 C08511006e='  Car, truck, or van - drove alone:' 
		 C08511007e='    Native'
		 C08511008e='    Foreign born:' 
		 C08511009e='      Naturalized U.S. citizen' 
		 C08511010e='      Not a U.S. citizen' 
		 C08511011e='  Car, truck, or van - carpooled:' 
		 C08511012e='    Native'
		 C08511013e='    Foreign born:' 
		 C08511014e='      Naturalized U.S. citizen' 
		 C08511015e='      Not a U.S. citizen' 
		 C08511016e='  Public transportation (excluding taxicab):' 
		 C08511017e='    Native'
		 C08511018e='    Foreign born:' 
		 C08511019e='      Naturalized U.S. citizen' 
		 C08511020e='      Not a U.S. citizen' 
		 C08511021e='  Taxicab, motorcycle, bicycle, walked, or other means:' 
		 C08511022e='    Native'
		 C08511023e='    Foreign born:' 
		 C08511024e='      Naturalized U.S. citizen' 
		 C08511025e='      Not a U.S. citizen' 
		 C08511026e='  Worked at home:' 
		 C08511027e='    Native'
		 C08511028e='    Foreign born:' 
		 C08511029e='      Naturalized U.S. citizen' 
		 C08511030e='      Not a U.S. citizen'; 

     
   INPUT
     
         FILEID $
         FILETYPE $  
         STUSAB $
		 CHARITER $
		 SEQUENCE $
		 LOGRECNO $
         B08406001e
         B08406002e
         B08406003e
         B08406004e
         B08406005e
         B08406006e
         B08406007e
         B08406008e
         B08406009e
         B08406010e
         B08406011e
         B08406012e
         B08406013e
         B08406014e
         B08406015e
         B08406016e
         B08406017e
         B08406018e
         B08406019e
         B08406020e
         B08406021e
         B08406022e
         B08406023e
         B08406024e
         B08406025e
         B08406026e
         B08406027e
         B08406028e
         B08406029e
         B08406030e
         B08406031e
         B08406032e
         B08406033e
         B08406034e
         B08406035e
         B08406036e
         B08406037e
         B08406038e
         B08406039e
         B08406040e
         B08406041e
         B08406042e
         B08406043e
         B08406044e
         B08406045e
         B08406046e
         B08406047e
         B08406048e
         B08406049e
         B08406050e
         B08406051e

         B08412001e
         B08412002e
         B08412003e
         B08412004e
         B08412005e
         B08412006e
         B08412007e
         B08412008e
         B08412009e
         B08412010e
         B08412011e
         B08412012e
         B08412013e
         B08412014e
         B08412015e
         B08412016e
         B08412017e
         B08412018e
         B08412019e
         B08412020e
         B08412021e
         B08412022e
         B08412023e
         B08412024e
         B08412025e
         B08412026e
         B08412027e
         B08412028e
         B08412029e
         B08412030e
         B08412031e
         B08412032e
         B08412033e
         B08412034e
         B08412035e
         B08412036e
         B08412037e
         B08412038e
         B08412039e

         B08511001e
         B08511002e
         B08511003e
		 B08511004e
     	 B08511005e
		 B08511006e
		 B08511007e
		 B08511008e
		 B08511009e
		 B08511010e
		 B08511011e
		 B08511012e
		 B08511013e
		 B08511014e
		 B08511015e
		 B08511016e
		 B08511017e
		 B08511018e
		 B08511019e
		 B08511020e
		 B08511021e
		 B08511022e
		 B08511023e
		 B08511024e
		 B08511025e
		 B08511026e
		 B08511027e
		 B08511028e
		 B08511029e
		 B08511030e
		 B08511031e
		 B08511032e
		 B08511033e
		 B08511034e
		 B08511035e

         C08406001e
		 C08406002e
		 C08406003e
		 C08406004e
		 C08406005e
		 C08406006e
		 C08406007e
		 C08406008e
		 C08406009e
		 C08406010e
		 C08406011e
		 C08406012e
		 C08406013e
		 C08406014e
		 C08406015e
		 C08406016e
		 C08406017e
		 C08406018e
		 C08406019e
		 C08406020e
		 C08406021e
		 C08406022e
		 C08406023e
		 C08406024e
		 C08406025e
		 C08406026e
		 C08406027e
		 C08406028e
		 C08406029e
		 C08406030e
		 C08406031e
		 C08406032e
		 C08406033e

		 C08412001e
		 C08412002e
		 C08412003e
		 C08412004e
		 C08412005e
		 C08412006e
		 C08412007e
		 C08412008e
		 C08412009e
		 C08412010e
		 C08412011e
		 C08412012e
		 C08412013e
		 C08412014e
		 C08412015e
		 C08412016e
		 C08412017e
		 C08412018e
		 C08412019e
		 C08412020e
		 C08412021e
		 C08412022e
		 C08412023e
		 C08412024e
		 C08412025e
		 C08412026e
		 C08412027e
		 C08412028e
		 C08412029e
		 C08412030e

		 C08511001e
		 C08511002e
		 C08511003e
		 C08511004e
		 C08511005e
		 C08511006e
		 C08511007e
		 C08511008e
		 C08511009e
		 C08511010e
		 C08511011e
		 C08511012e
		 C08511013e
		 C08511014e
		 C08511015e
		 C08511016e
		 C08511017e
		 C08511018e
		 C08511019e
		 C08511020e
		 C08511021e
		 C08511022e
		 C08511023e
		 C08511024e
		 C08511025e
		 C08511026e
		 C08511027e
		 C08511028e
		 C08511029e
		 C08511030e;
RUN;