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

         B08406001m='Total (MOE)'
         B08406002m='    Car, truck, or van: (MOE)'
         B08406003m='      Drove alone (MOE)'
         B08406004m='      Carpooled: (MOE)'
         B08406005m='        In 2-person carpool (MOE)'
         B08406006m='        In 3-person carpool (MOE)'
         B08406007m='        In 4-or-more-person carpool (MOE)'
         B08406008m='    Public transportation (excluding taxicab): (MOE)'
         B08406009m='      Bus or trolley bus (MOE)'
         B08406010m='      Streetcar or trolley car (carro publico in Puerto Rico) (MOE)'
         B08406011m='      Subway or elevated (MOE)'
         B08406012m='      Railroad (MOE)'
         B08406013m='      Ferryboat (MOE)'
         B08406014m='    Bicycle (MOE)'
         B08406015m='    Walked (MOE)'
         B08406016m='    Taxicab, motorcycle, or other means (MOE)'
         B08406017m='    Worked at home (MOE)'
         B08406018m='  Male: (MOE)'
         B08406019m='    Car, truck, or van: (MOE)'
         B08406020m='      Drove alone (MOE)'
         B08406021m='      Carpooled: (MOE)'
         B08406022m='        In 2-person carpool (MOE)'
         B08406023m='        In 3-person carpool (MOE)'
         B08406024m='        In 4-or-more-person carpool (MOE)'
         B08406025m='    Public transportation (excluding taxicab): (MOE)'
         B08406026m='      Bus or trolley bus (MOE)'
         B08406027m='      Streetcar or trolley car (carro publico in Puerto Rico) (MOE)'
         B08406028m='      Subway or elevated (MOE)'
         B08406029m='      Railroad (MOE)'
         B08406030m='      Ferryboat (MOE)'
         B08406031m='    Bicycle (MOE)'
         B08406032m='    Walked (MOE)'
         B08406033m='    Taxicab, motorcycle, or other means (MOE)'
         B08406034m='    Worked at home (MOE)'
         B08406035m='  Female: (MOE)'
         B08406036m='    Car, truck, or van: (MOE)'
         B08406037m='      Drove alone (MOE)'
         B08406038m='      Carpooled: (MOE)'
         B08406039m='        In 2-person carpool (MOE)'
         B08406040m='        In 3-person carpool (MOE)'
         B08406041m='        In 4-or-more-person carpool (MOE)'
         B08406042m='    Public transportation (excluding taxicab): (MOE)'
         B08406043m='      Bus or trolley bus (MOE)'
         B08406044m='      Streetcar or trolley car (carro publico in Puerto Rico) (MOE)'
         B08406045m='      Subway or elevated (MOE)'
         B08406046m='      Railroad (MOE)'
         B08406047m='      Ferryboat (MOE)'
         B08406048m='    Bicycle (MOE)'
         B08406049m='    Walked (MOE)'
         B08406050m='    Taxicab, motorcycle, or other means (MOE)'
         B08406051m='    Worked at home (MOE)'
     
         /*SEX OF WORKERS BY TRAVEL TIME TO WORK FOR WORKPLACE GEOGRAPHY*/         
         /*Universe:  Workers 16 years and over who did not work at home*/

         B08412001m='Total: (MOE)'
         B08412002m='    Less than 5 minutes (MOE)'
         B08412003m='    5 to 9 minutes (MOE)' 
         B08412004m='    10 to 14 minutes (MOE)' 
         B08412005m='    15 to 19 minutes (MOE)' 
         B08412006m='    20 to 24 minutes (MOE)' 
         B08412007m='    25 to 29 minutes (MOE)' 
         B08412008m='    30 to 34 minutes (MOE)' 
         B08412009m='    35 to 39 minutes (MOE)' 
         B08412010m='    40 to 44 minutes (MOE)' 
         B08412011m='    45 to 59 minutes (MOE)' 
         B08412012m='    60 to 89 minutes (MOE)' 
         B08412013m='    90 or more minutes (MOE)' 
         B08412014m='  Male: (MOE)' 
         B08412015m='    Less than 5 minutes (MOE)'
         B08412016m='    5 to 9 minutes (MOE)' 
         B08412017m='    10 to 14 minutes (MOE)' 
         B08412018m='    15 to 19 minutes (MOE)' 
         B08412019m='    20 to 24 minutes (MOE)' 
         B08412020m='    25 to 29 minutes (MOE)' 
         B08412021m='    30 to 34 minutes (MOE)' 
         B08412022m='    35 to 39 minutes (MOE)' 
         B08412023m='    40 to 44 minutes (MOE)' 
         B08412024m='    45 to 59 minutes (MOE)' 
         B08412025m='    60 to 89 minutes (MOE)' 
         B08412026m='    90 or more minutes (MOE)' 
         B08412027m='  Female: (MOE)' 
         B08412028m='    Less than 5 minutes (MOE)'
         B08412029m='    5 to 9 minutes (MOE)' 
         B08412030m='    10 to 14 minutes (MOE)' 
         B08412031m='    15 to 19 minutes (MOE)' 
         B08412032m='    20 to 24 minutes (MOE)' 
         B08412033m='    25 to 29 minutes (MOE)' 
         B08412034m='    30 to 34 minutes (MOE)' 
         B08412035m='    35 to 39 minutes (MOE)' 
         B08412036m='    40 to 44 minutes (MOE)' 
         B08412037m='    45 to 59 minutes (MOE)' 
         B08412038m='    60 to 89 minutes (MOE)' 
         B08412039m='    90 or more minutes (MOE)' 

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

         B08511001m='Total: (MOE)'
         B08511002m='    Native (MOE)'
         B08511003m='    Foreign born: (MOE)' 
		 B08511004m='      Naturalized U.S. citizen (MOE)' 
     	 B08511005m='      Not a U.S. citizen (MOE)' 
		 B08511006m='  Car, truck, or van - drove alone: (MOE)' 
		 B08511007m='    Native (MOE)' 
		 B08511008m='    Foreign born: (MOE)' 
		 B08511009m='      Naturalized U.S. citizen (MOE)' 
		 B08511010m='      Not a U.S. citizen (MOE)' 
		 B08511011m='  Car, truck, or van - carpooled: (MOE)' 
		 B08511012m='    Native (MOE)' 
		 B08511013m='    Foreign born: (MOE)' 
		 B08511014m='      Naturalized U.S. citizen (MOE)' 
		 B08511015m='      Not a U.S. citizen (MOE)' 
		 B08511016m='  Public transportation (excluding taxicab): (MOE)' 
		 B08511017m='    Native (MOE)'
		 B08511018m='    Foreign born: (MOE)' 
		 B08511019m='      Naturalized U.S. citizen (MOE)' 
		 B08511020m='      Not a U.S. citizen (MOE)' 
		 B08511021m='  Walked: (MOE)' 
		 B08511022m='    Native (MOE)'
		 B08511023m='    Foreign born: (MOE)' 
		 B08511024m='      Naturalized U.S. citizen (MOE)' 
		 B08511025m='      Not a U.S. citizen (MOE)' 
		 B08511026m='  Taxicab, motorcycle, bicycle, or other means: (MOE)' 
		 B08511027m='    Native (MOE)'
		 B08511028m='    Foreign born: (MOE)' 
		 B08511029m='      Naturalized U.S. citizen (MOE)' 
		 B08511030m='      Not a U.S. citizen (MOE)' 
		 B08511031m='  Worked at home: (MOE)' 
		 B08511032m='    Native (MOE)'
		 B08511033m='    Foreign born: (MOE)' 
		 B08511034m='      Naturalized U.S. citizen (MOE)' 
		 B08511035m='      Not a U.S. citizen (MOE)' 

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

         C08406001m='Total: (MOE)'
		 C08406002m='    Car, truck, or van: (MOE)'
		 C08406003m='      Drove alone (MOE)' 
		 C08406004m='      Carpooled: (MOE)' 
		 C08406005m='        In 2-person carpool (MOE)' 
		 C08406006m='        In 3-person carpool (MOE)' 
		 C08406007m='        In 4-or-more-person carpool (MOE)' 
		 C08406008m='    Public transportation (excluding taxicab) (MOE)' 
		 C08406009m='    Walked (MOE)' 
		 C08406010m='    Taxicab, motorcycle, bicycle, or other means (MOE)' 
		 C08406011m='    Worked at home (MOE)' 
		 C08406012m='  Male: (MOE)' 
		 C08406013m='    Car, truck, or van: (MOE)' 
		 C08406014m='      Drove alone (MOE)' 
		 C08406015m='      Carpooled: (MOE)' 
		 C08406016m='        In 2-person carpool (MOE)' 
		 C08406017m='        In 3-person carpool (MOE)' 
		 C08406018m='        In 4-or-more-person carpool (MOE)' 
		 C08406019m='    Public transportation (excluding taxicab) (MOE)' 
		 C08406020m='    Walked (MOE)' 
		 C08406021m='    Taxicab, motorcycle, bicycle, or other means (MOE)' 
		 C08406022m='    Worked at home (MOE)' 
		 C08406023m='  Female: (MOE)' 
		 C08406024m='    Car, truck, or van: (MOE)' 
		 C08406025m='      Drove alone (MOE)' 
		 C08406026m='      Carpooled: (MOE)' 
		 C08406027m='        In 2-person carpool (MOE)' 
		 C08406028m='        In 3-person carpool (MOE)' 
		 C08406029m='        In 4-or-more-person carpool (MOE)' 
		 C08406030m='    Public transportation (excluding taxicab) (MOE)' 
		 C08406031m='    Walked (MOE)' 
		 C08406032m='    Taxicab, motorcycle, bicycle, or other means (MOE)' 
		 C08406033m='    Worked at home (MOE)' 

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

		 C08412001m='Total: (MOE)'
		 C08412002m='    Less than 10 minutes (MOE)'
		 C08412003m='    10 to 14 minutes (MOE)' 
		 C08412004m='    15 to 19 minutes (MOE)' 
		 C08412005m='    20 to 24 minutes (MOE)' 
		 C08412006m='    25 to 29 minutes (MOE)' 
		 C08412007m='    30 to 34 minutes (MOE)' 
		 C08412008m='    35 to 44 minutes (MOE)' 
		 C08412009m='    45 to 59 minutes (MOE)' 
		 C08412010m='    60 or more minutes (MOE)' 
		 C08412011m='  Male: (MOE)'
		 C08412012m='    Less than 10 minutes (MOE)'
		 C08412013m='    10 to 14 minutes (MOE)' 
		 C08412014m='    15 to 19 minutes (MOE)' 
		 C08412015m='    20 to 24 minutes (MOE)' 
		 C08412016m='    25 to 29 minutes (MOE)' 
		 C08412017m='    30 to 34 minutes (MOE)' 
		 C08412018m='    35 to 44 minutes (MOE)' 
		 C08412019m='    45 to 59 minutes (MOE)' 
		 C08412020m='    60 or more minutes (MOE)' 
		 C08412021m='  Female: (MOE)'
		 C08412022m='    Less than 10 minutes (MOE)'
		 C08412023m='    10 to 14 minutes (MOE)' 
		 C08412024m='    15 to 19 minutes (MOE)' 
		 C08412025m='    20 to 24 minutes (MOE)' 
		 C08412026m='    25 to 29 minutes (MOE)' 
		 C08412027m='    30 to 34 minutes (MOE)' 
		 C08412028m='    35 to 44 minutes (MOE)' 
		 C08412029m='    45 to 59 minutes (MOE)' 
		 C08412030m='    60 or more minutes (MOE)' 

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

		 C08511001m='Total: (MOE)'
		 C08511002m='    Native (MOE)'
		 C08511003m='    Foreign born: (MOE)' 
		 C08511004m='      Naturalized U.S. citizen (MOE)' 
		 C08511005m='      Not a U.S. citizen (MOE)' 
		 C08511006m='  Car, truck, or van - drove alone: (MOE)' 
		 C08511007m='    Native (MOE)'
		 C08511008m='    Foreign born: (MOE)' 
		 C08511009m='      Naturalized U.S. citizen (MOE)' 
		 C08511010m='      Not a U.S. citizen (MOE)' 
		 C08511011m='  Car, truck, or van - carpooled: (MOE)' 
		 C08511012m='    Native (MOE)'
		 C08511013m='    Foreign born: (MOE)' 
		 C08511014m='      Naturalized U.S. citizen (MOE)' 
		 C08511015m='      Not a U.S. citizen (MOE)' 
		 C08511016m='  Public transportation (excluding taxicab): (MOE)' 
		 C08511017m='    Native (MOE)'
		 C08511018m='    Foreign born: (MOE)' 
		 C08511019m='      Naturalized U.S. citizen (MOE)' 
		 C08511020m='      Not a U.S. citizen (MOE)' 
		 C08511021m='  Taxicab, motorcycle, bicycle, walked, or other means: (MOE)' 
		 C08511022m='    Native (MOE)'
		 C08511023m='    Foreign born: (MOE)' 
		 C08511024m='      Naturalized U.S. citizen (MOE)' 
		 C08511025m='      Not a U.S. citizen (MOE)' 
		 C08511026m='  Worked at home: (MOE)' 
		 C08511027m='    Native (MOE)'
		 C08511028m='    Foreign born: (MOE)' 
		 C08511029m='      Naturalized U.S. citizen (MOE)' 
		 C08511030m='      Not a U.S. citizen (MOE)'; 
     
   INPUT
     
         FILEID $
         FILETYPE $  
         STUSAB $
		 CHARITER $
		 SEQUENCE $
		 LOGRECNO $
         B08406001m
         B08406002m
         B08406003m
         B08406004m
         B08406005m
         B08406006m
         B08406007m
         B08406008m
         B08406009m
         B08406010m
         B08406011m
         B08406012m
         B08406013m
         B08406014m
         B08406015m
         B08406016m
         B08406017m
         B08406018m
         B08406019m
         B08406020m
         B08406021m
         B08406022m
         B08406023m
         B08406024m
         B08406025m
         B08406026m
         B08406027m
         B08406028m
         B08406029m
         B08406030m
         B08406031m
         B08406032m
         B08406033m
         B08406034m
         B08406035m
         B08406036m
         B08406037m
         B08406038m
         B08406039m
         B08406040m
         B08406041m
         B08406042m
         B08406043m
         B08406044m
         B08406045m
         B08406046m
         B08406047m
         B08406048m
         B08406049m
         B08406050m
         B08406051m
     
         B08412001m
         B08412002m
         B08412003m
         B08412004m
         B08412005m
         B08412006m
         B08412007m
         B08412008m
         B08412009m
         B08412010m
         B08412011m
         B08412012m
         B08412013m
         B08412014m
         B08412015m
         B08412016m
         B08412017m
         B08412018m
         B08412019m
         B08412020m
         B08412021m
         B08412022m
         B08412023m
         B08412024m
         B08412025m
         B08412026m
         B08412027m
         B08412028m
         B08412029m
         B08412030m
         B08412031m
         B08412032m
         B08412033m
         B08412034m
         B08412035m
         B08412036m
         B08412037m
         B08412038m
         B08412039m

         B08511001m
         B08511002m
         B08511003m
		 B08511004m
     	 B08511005m
		 B08511006m
		 B08511007m
		 B08511008m
		 B08511009m
		 B08511010m
		 B08511011m
		 B08511012m
		 B08511013m
		 B08511014m
		 B08511015m
		 B08511016m
		 B08511017m
		 B08511018m
		 B08511019m
		 B08511020m
		 B08511021m
		 B08511022m
		 B08511023m
		 B08511024m
		 B08511025m
		 B08511026m
		 B08511027m
		 B08511028m
		 B08511029m
		 B08511030m
		 B08511031m
		 B08511032m
		 B08511033m
		 B08511034m
		 B08511035m

         C08406001m
		 C08406002m
		 C08406003m
		 C08406004m
		 C08406005m
		 C08406006m
		 C08406007m
		 C08406008m
		 C08406009m
		 C08406010m
		 C08406011m
		 C08406012m
		 C08406013m
		 C08406014m
		 C08406015m
		 C08406016m
		 C08406017m
		 C08406018m
		 C08406019m
		 C08406020m
		 C08406021m
		 C08406022m
		 C08406023m
		 C08406024m
		 C08406025m
		 C08406026m
		 C08406027m
		 C08406028m
		 C08406029m
		 C08406030m
		 C08406031m
		 C08406032m
		 C08406033m

		 C08412001m
		 C08412002m
		 C08412003m
		 C08412004m
		 C08412005m
		 C08412006m
		 C08412007m
		 C08412008m
		 C08412009m
		 C08412010m
		 C08412011m
		 C08412012m
		 C08412013m
		 C08412014m
		 C08412015m
		 C08412016m
		 C08412017m
		 C08412018m
		 C08412019m
		 C08412020m
		 C08412021m
		 C08412022m
		 C08412023m
		 C08412024m
		 C08412025m
		 C08412026m
		 C08412027m
		 C08412028m
		 C08412029m
		 C08412030m

		 C08511001m
		 C08511002m
		 C08511003m
		 C08511004m
		 C08511005m
		 C08511006m
		 C08511007m
		 C08511008m
		 C08511009m
		 C08511010m
		 C08511011m
		 C08511012m
		 C08511013m
		 C08511014m
		 C08511015m
		 C08511016m
		 C08511017m
		 C08511018m
		 C08511019m
		 C08511020m
		 C08511021m
		 C08511022m
		 C08511023m
		 C08511024m
		 C08511025m
		 C08511026m
		 C08511027m
		 C08511028m
		 C08511029m
		 C08511030m;
RUN;