How to import or read a dat file without giving variable names?

[Apolloash]

Dear friends, I would like to import or read a dat file without giving variable names, and then export the dat file into a csv file. My attempt is, 

DATA mydata;

   INFILE ".\data.dat";

 RUN;

I know I need to add another line of code, "input var1 var2". But I do not know the variables names. Thank you so much! 

[Patrick]

Assuming your .dat file is textual is there anything between Import and Export you want to do with the data or are you just trying to create a copy of the .dat file with a .csv extension?
 
If you want to modify anything in the data:
It would help if you post a sample of the data in your .dat file as well as a sample how the same data needs to look like in the .csv
 
.\data.dat
What OS are you under? The dot indicates Unix/Linux but the backslash looks like Windows.

[Apolloash]

Dear friend, thank you a lot for your kind help and reply! I might post it later. 

[PGStats]

You don't need to create a dataset. You can read and write in the same _null_ data step. Given the space separated text file A.txt

Alfred 14 69 112.5
Alice 13 56.5 84
Barbara 13 65.3 98
Carol 14 62.8 102.5
Henry 14 63.5 102.5
James 12 57.3 83
Jane 12 59.8 84.5
Janet 15 62.5 112.5
Jeffrey 13 62.5 84
John 12 59 99.5
Joyce 11 51.3 50.5
Judy 14 64.3 90
Louise 12 56.3 77
Mary 15 66.5 112
Philip 16 72 150
Robert 12 64.8 128
Ronald 15 67 133
Thomas 11 57.5 85
William 15 66.5 112

This data step will create a comma separated file B.csv

data _null_;
infile "/home/.../a.txt" truncover;
input line $200.;
file "/home/.../b.csv" dsd; /* Note the use of option DSD here */
length field $32;
do i = 1 to countw(line," ");
    field = scan(line, i, " ");
    put field @;
    end;
put;
run;

File B.csv :

Alfred,14,69,112.5
Alice,13,56.5,84
Barbara,13,65.3,98
Carol,14,62.8,102.5
Henry,14,63.5,102.5
James,12,57.3,83
Jane,12,59.8,84.5
Janet,15,62.5,112.5
Jeffrey,13,62.5,84
John,12,59,99.5
Joyce,11,51.3,50.5
Judy,14,64.3,90
Louise,12,56.3,77
Mary,15,66.5,112
Philip,16,72,150
Robert,12,64.8,128
Ronald,15,67,133
Thomas,11,57.5,85
William,15,66.5,112

[Kurt_Bremser]

If you need to change the structure (e.g. from a fixed-width stream to variable-width with record separators and column delimiters), then you need to know the column attributes anyway. Getting and writing the variable names on top of that is a piece of cake.

OTOH, if you only need to switch column delimiters, that can be done by manipulating the automatic variable _infile_.

On the gripping hand, if your .dat file actually has an internal proprietary structure (with a header block like SAS datasets have), then you need a means of decoding that first, before you can create the simple text output of a CSV file.

PS if your CSV output requires a header line, and that header line is not present in a similar form in the .dat file, you MUST know the column names anyway.

[Tom]

If you are just reading from one text file and writing to another the names you used in your data step to get that done doesn't matter.

But you will need to describe in more detail what you are trying to do.  What is a .dat file? Is it just a text file?  How is it structured? Does it have multiple values on a line like a CSV file does?  How do you know when one value ends and the next value starts?

[Apolloash]

Dear friends, thank you for your replies! I attached the link to the data set here (https://drive.google.com/file/d/1RO5H7LFr1dCIf-jZkHGOEVI-_iJOJgUi/view?usp=sharing ). The data set contains not variable names. And in some rows, there are some missing columns for some variables. So it is hard export the data aligned as the first row. Thank you! 

[Tom]

---

@Apolloash wrote:

Dear friends, thank you for your replies! I attached the link to the data set here (https://drive.google.com/file/d/1RO5H7LFr1dCIf-jZkHGOEVI-_iJOJgUi/view?usp=sharing ). The data set contains not variable names. And in some rows, there are some missing columns for some variables. So it is hard export the data aligned as the first row. Thank you! 

---

I don't see an "missing columns" at all.  It looks like you have about 140K+ observations that are each 1276 bytes long. All of the fields appear to be fixed length. 

233   data _null_;
234     infile "c:\downloads\data.dat" ;
235     input;
236     if mod(_n_,10000)=1 then
237     list;
238   run;

NOTE: The infile "c:\downloads\data.dat" is:
      Filename=c:\downloads\data.dat,
      RECFM=V,LRECL=32767,
      File Size (bytes)=181390188,
      Last Modified=17Jun2020:10:12:51,
      Create Time=17Jun2020:10:12:42

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
1         610905110108708122018 120100 1 1 1-1 112-1-1-1  19539929 1 1 7 8 2 0 207011 1  2-1-1-1-1 36 01 33
      98  8600002103000        2-1540 4-1 2 2   244 1-1 9   1   0 0 2 2 5 2 57 57 57 1 0 0 1 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-160-1-1 60-1-1-1-1 2-1 2-160-1 60-1      2 5 5-1 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -122 1 1 1 6-1-1-1 -1  -1 1 2-1-1-1-1 1 2 1 2 4      -1-1       4 3 3 1 2 2-1 2 8-140-1 8-1 110-1
     486   2-1 1-1 1 1 1 2 6 2 2  -1  -1  -1  -10-1  1038460          -1      -10  52 1-1-1-1-1-1-1 2-1-1 2
     583    19539929  27943095  78233096  19539929  19452786 0 0 1 0-1 0 0 0 1 0-1 050 0 0 1 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777   0 0 1 1 1-1-1 0 0 0 1 0 1-1-1-1 0 1 1    1 1-1-1-1       1 1 1        1950045078602310  -1  -115
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 1 2 2 2 1 0 0 0 0 0 0 0-1-1-1-1-1 1 1 1202020
     971                                 1 2 1 2100 20 -1 -1 20 -1 100150 3 -1 -1 1 2-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 2 2 2 3-1 3-1 1 3 2-1 2-1-1-1 2-1-1-1 2-1 2-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1 2-1-1 1 2-1-1  22847593  22847593 1 2 2 1 2 2 310-1-1  -1 2 2 310 1 1 0  -6-1-
    1262  1  -1 1 0  -663 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
10001     068008552104411122018 1  100 1 1 1-1 115-1-1-1  32439384 1 4 1 7-1 0 207011 2  2-1-1-1-1 23 18 16
      98  9800894107176        4 1100-1-1 2-1  -1-1 1-1 9   4   1 3 1 2-1 1 57 57 57 1 0 0-1-1-1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     389  -1-1-1-1-1-1-1-1-1 -1  -1-1-1-1-1-1-1-1-1-1-1-1      -1-1      -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1-1-1-1-1
     583    31057694         0         0  31057694         0 0 0-1-1-1 0 0 0 1 0-1 010 0 0 0 0-1 0 0 0-1-1-
     680  1-1 0-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 5197 4-1-1-1       0 0 0               0  -1  -1  -1  -1-1
     874  -1-1-1-1-1 1 1 2 1 1-1 0 0 0 0-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0-1-1-1-1-1-1-1-1-1-1-1
     971                                 1 2 1 2140 30 -1 -1 60 -1 170200 2 -1 80 2-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1  37320589  39838292 1 2 1 1 1 0  -6 1 0  -6 1 0  -6 1 1 0  -6 1
    1262  0  -6 1 0  -632 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
20001     426570311067992122018 120100 1 1 2 1 116-1-1-1  13911139 1 7 1 1 1 1 009011 2  2-1-1-1-1 48 49 41
      98  6200002105482        7-1210 1 5 2 2   241 1-1 9   4   2 1 3 2 1 2 57 57 57 1 0 0 2 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-128-1-1 28 3-1-1-1 2-1 2-128-1 28-1      2 5 4 3 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -115 1 1 2 2-11122 -1  -1 1 7-1-1-1-1-1-1-1 4 2      -1-1       2-1-1 1 2 4-1 1 6-146-113-1 111-1
     486   3-1 2 1 1 1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1 1 1 2 2
     583    13911139         0         0  13911139  13843098 0 0 1-1-1 0 0 0 0 0-1 050 0 0 0 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 0 1 1 0 1 0 1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0 9905 4-1-1 3       1 1 0        1384967486804110  -1  -118
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 2-1-1 0 0 0
     971                                 1 2 1 2350140 -1 -1130 -1 340320 2 -1 80 2-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1  16707127  16707127 1 2 1 1 1 0  -6-1-1  -1 1 0  -6 1 1 0  -6-1-
    1262  1  -1 1 0  -687 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
30001     244140110703028122018 120100 1 1 1-1 115-1-1-1  10162141 1 5 1 7 2 0 207011 1  2-1-1-1-1 11 44 39
      98  3000002105148        1-1450 1 2 2 2   239 1-1 9   1   1 1 1 2 1 2 57 57129 1 0 0 1 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-140-1-1 40-1-1-1-1 2-1 2-140-1 40-1      2 5 5-1 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -118 1 1 1 4-1-1-1 -1  -1 1 2-1-1-1-1 1 2 2 4 4      -1-1       4 3 3 1 2 4-1 1 6-122-1 2-1 1 5-1
     486   1-1 1 1 1 1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1 2-1-1 2
     583    10162141  14532380         0  10162141   9989174 3 1 1-1-1 0 0 0 1 0-1 050 0 0 0 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 1 115051 1 2 4-1       0 0 1        100117125580 950  -1  -1 7
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 1 1 2202020
     971                                 1 1 2 2350 30 80  0 -1 -1 400300 3 -1 -1 2-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1  12855653  12855653 1 2 1 1 1 0  -6 1 0  -6 1 0  -6 1 1 0  -6 1
    1262  0  -6 1 0  -615 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
40001     060018509006391122018 120100 1 1 1-1 116-1-1-1  39855786 1 4 1 2 2 0 209011 2  2-1-1-1-1 48 08 19
      98  7400311116216        3-1400 1 1 2 2   245 1 1 9   2   1 2 1 1 1 2303303303 5 019 2 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-134-1-1 34 2-1 2-1 2-1 2-134-1 34-1      2 5 4 3 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -116 1 1 2 2-11218 -1  -1 1 7-1-1-1-1 1 2 1 5 4      -1-1       4 3 3 1 2 4-1 1 6-141-110-1 110-1
     486   2-1 1 1 1 1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1 2-1-1 2
     583    39855786  56995806         0  39855786  39253109 3 2 1-1-1 0 0 0 1 0-1 050 0 0 0 0 1 0 021-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 0 1 0 0 1 0 1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 1 119817 2-1-1-1       1 1 1        3932281881903060  -1  -116
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 1 1 1202020
     971                                 1 1 1 2250 40 50 10150 -1 400400 2 -1180 2-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1  56989599  56989599 1 2 1 1 1 0  -6 1 0  -6 1 0  -6 1 1 0  -6 1
    1262  0  -6 1 0  -684 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
50001     000911378592003122018 120101 2 1 1-1 1 9-1-1-1  29831658 1 5 1 3 2 0 209011 2  2-1-1-1-1 11 09 14
      98  8600011104408        4 1180 6-1 1 2   240 1 4 9   3   1 3 1 1 7 2329329 57 3 024 2 7 2-1-1 2-1 2-
     195  1-1-1-1-1-1 2 2-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1 2-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1 2-1-1-1-1-1-1-1 4-1-1-1-1-1-1-1-1 3-1-1 2
     389  -1 0 4-1-1-1-1-1-1 -1  -1 0 1 2-1-1-1-1-1-1-1-1      -1-1      -1-1-1 0-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1 3 1-1 1 1 2 1
     583    35202111  50319305         0  35202111  35882664 0 0 0-1-1 0 0 0 1 0-1 010 0 0 1 0 1 0 0 0-1-1-
     680  1 0 0 0 1-1-1-1-1-1-1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 1 1 1 1 1 1 1 1 1 1-1-1-1-1-1-1
     777  -1-1-1-1-1 0 0-1-1-1-1-1-1 1 1 0 0 0 024820 3-1-1 1       1 1 0        35990414  -1  -1  -1  -1-1
     874  -1-1-1-1-1 0 1 2 1 1-1 0 0 0 0 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 2-1-120 0 0
     971                                 1 1 1 2160  0 20  0 10 -1 190200 3 -1 -1 1 2-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0 1 1 2 2-1 0 3 1 1 2 1 1 1 2-1-1-1 1 2 1 5 2-1-1-1 2-1 2-1-1-1 1 1 1 1 2 2 2-1-1-1 2-1-1
    1165  -1 2-1-1-1 2-1-1-1 2-1-1 2 2-1-1  39873601  39780998 1 1 2 2 3 7 602 2 3 754 3 4 523 2 3 6 543 2
    1262  2 585 3 4 52316 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
60001     131192004610656122018 1  100 1 1 1-1 1 7-1-1-1  20443876 1 1 6 7-1 0 207011 1  2-1-1-1-1 24 19 00
      98  0000003200000        2-1720 4-1 1 2   239 1-1 9   1   0 0 2 2 5 2 57 57 57 1 0 0 1 5 3-1-1 2-1-1-
     195  1 1-1 2-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 2
     389  -1 0 4-1-1-1-1-1-1 -1  -1 0 1 2-1-1-1-1-1-1-1-1      -1-1      -1-1-1 0-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1 2-1-1-1-1
     583    20443876  29223294         0  20443876  21600251 0 0 0-1-1 0 0 0 1 0-1 050 0 0 1 0 1 0 0 0-1-1-
     680  1 0 0 0 0-1-1-1-1-1-1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1 1 1 1 1 1 1 1 1 1 1-1-1-1-1-1-1
     777  -1-1-1-1-1 0 0-1-1-1-1-1-1 1 1 1-1-1-129836 1 1-1-1       0 1 1        20722126  -1  -1  -1  -1-1
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 023-1-1-1-1-1 2-1-120 0 0
     971                                 1 1 2 2120 10 10  0 -1 -1 120100 3 -1 -1 2-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1  28284792  28284792 1 2 1 1 1 0  -6-1-1  -1 1 0  -6 1 1 0  -6-1-
    1262  1  -1 1 0  -642 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
70001     985070548431004122018 220100 1 1 1-1 1 8-1-1-1  13636730 1 2 1 6 1 1 207011 1  2-1-1-1-1 48 49 41
      98  1000534102000        3-1801 1 1 1 1   243 1-1 9   2   1 2 1 2 1 2 57 57 57 1 0 0 1 5 3-1-1 2-1-1-
     195  1 1-1 2-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 2
     389  -1 0 4-1-1-1-1-1-1 -1  -1 0 1 2-1-1-1-1-1-1-1-1      -1-1      -1-1-1 0-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1 2-1-1-1-1
     583    13636730  19387825         0  13563231  12556061 0 0 0-1-1 0 0 0 1 0-1 050 0 0 0 0 0 0 0 0-1-1-
     680  1 0 0 0 0-1-1-1-1-1-1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1 1 1 1 1 1 1 1 1 1 1-1-1-1-1-1-1
     777  -1-1-1-1-1 0 0-1-1-1-1-1-1 1 1 1-1-1-134389 2-1-1-1       1 1 1        13997712  -1  -1  -1  -1-1
     874  -1 5-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 2-1-120 0 0
     971                                 1 2 1 2 80 10 -1 -1 20 -1  90 90 3 -1 -1 2 2-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1 2 1 2 2 3-1 2-1-1-1 2-1-1-1 2-1-1-1 2-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1 2 1 2-1-1 1 2-1-1  16614836  15858485 1 1 1 1 2 2 310-1-1  -1 2 2 310 1 2 1 172-1-
    1262  1  -1 2 1 17287 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
80001     008260110015528122018 1  100 1 5 1-1 1 9-1-1-1  12054192 1 6 4 3-1 0 209011 1  2-1-1-1-1 37 05 30
      98  7800002104340        4 1110-1-1 2-1  -1-1 6-1 9   2   1 3 1 2-1 1 57 57 57 1 0 0-1-1-1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     389  -1-1-1-1-1-1-1-1-1 -1  -1-1-1-1-1-1-1-1-1-1-1-1      -1-1      -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1-1-1-1-1
     583    11298404         0         0  11298404         0 0 0-1-1-1 0 0 0 1 0-1 0 0 0 0 0 0-1 0 0 0-1-1-
     680  1-1 0-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-139267 2-1-1-1       0 0 0               0  -1  -1  -1  -1-1
     874  -1-1-1-1-1 1-1 1-1 1-150 050 0-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0-1-1-1-1-1-1-1-1-1-1-1
     971                                 1 1 1 2450  0 -1 -1 70 -1 570500 2 -1200 1 2-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0 1 1 2 2-1 0 2 2 2 3-1 3-1 2-1-1-1 2-1-1-1 2-1-1-1 2-1-1-1-1-1 3-1 3-1 3-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1 2-1-1 1 2-1-1  17226365  17343476 1 1 2 1 2 1 143 1 0  -6 2 1 172 1 1 0  -6 1
    1262  0  -6 1 0  -671 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
90001     207136214010472122018 120100 1 1 1-1 111-1-1-1   6767713 1 3 4 7 2 1 207011 1  2-1-1-1-1 35 10 41
      98  5400054103000        4 1 70-1-1 1-1  -1-1 1-1 9   2   1 3 1 2-1 1 57 57 57 1 0 0-1-1-1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     389  -1-1-1-1-1-1-1-1-1 -1  -1-1-1-1-1-1-1-1-1-1-1-1      -1-1      -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1-1-1-1-1
     583     6739235         0         0   6739235         0 0 0-1-1-1 0 0 0 1 0-1 0 0 0 0 0 0-1 0 0 0-1-1-
     680  1-1 0-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-143696 2-1-1-1       0 0 0               0  -1  -1  -1  -1-1
     874  -1-1-1-1-1 1 3 1 1 1-1 0 0 0 0-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0-1-1-1-1-1-1-1-1-1-1-1
     971                                 1 2 1 2 80 20 -1 -1 60 -1 120110 2 -1 30 1 2-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0 1 2 2 2-1 0 1 2 2 2 2 2 1 2-1-1-1 1 3 2-1 1 3 2-1 2-1 2-1-1-1 3-1 3-1 2 2 2-1-1-1 2-1-1
    1165  -1 2-1-1-1 2-1-1-1 2-1-1 1 2-1-1   9031325   9479004 1 2 1 2 3 6 543 1 1 411 3 5 616 1 2 1 143 1
    1262  0  -6 2 1 17251 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
100001    851682008430576122018 220100 1 1 1-1 111-1-1-1   3723998 1 4 1 8 2 0 207011 2  1 1-1-1-1 24 38 00
      98  0000003200000        3-1380 1 1 2 2   242 1-1 9   2   1 2 1 2 1 2 57 57 57 1 0 0 1 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-1-4-1 1 -4-1-1-1 5-1-1-1-115-1 15-1      2 3 6 1 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -114 1 1 1 7-1 0 5 -1  -1 1 4-1-1-1-1 1 2 1 4 4      -1-1       4 3 3 1 2 4-1 1 6-1 4-119-1 1 3-1
     486   7-1 5-1 1 1 1 2 1-1 1  -1  -118001800020   360000          -1      -10  -1 2 2-1-1-1-1-1 2-1-1 2
     583     3723998   5325507  14796834   3723998   3659216 6 2 1 0 0 0 0 0 1 0-1 050 0 0 0 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 140 0 1 1 1 0 1 041 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777   0 0 0 0 1-1-1 1 1 0 1 0 0-1-1-1 0 1 148280 2-1-1 3       1 1 0         3669653 7706420  -1  -1 3
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 2-1-120 0 0
     971                                 1 1 1 2120  0 20  0 40 -1 180180 3 -1 -1 2 2-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0 2-1 2 2-1 0 1 3-1 3-1 3-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 3-1 3-1 3-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1 2-1-1 2 2-1-1   4759686   4759686 1 1 1 1 1 0  -6 1 0  -6 1 0  -6 1 1 0  -6 1
    1262  0  -6 1 0  -644 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
110001    560830744281000122018 120100 1 1 1-1 110-1-1-1  10804598 1 4 1 8 2 0 207111 2  2-1-1-1-1 37 05 22
      98  2200002103000        3-1500 1 1 2 2   239 3-1 9   2   1 2 1 2 1 2 57 57 57 1 0 0 2 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-140-1-1 40-1-1-1-1 2-1 2-140-1 40-1      2 5 5-1 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -118 1 1 1 4-1-1-1 -1  -1 1 2-1-1-1-1 1 2 1 4 2      -1-1       4 3 3 1 2 4-1 1 6-122-114-1 1 5-1
     486   3-1 2 1 1 1 1 2 1-1 1  -1  -111301130040   452000          -1      -10  -1 2 2-1-1-1-1-1 2-1-1 2
     583    10804598  15451126  43207195  10804598  10756105 4 1 1 1 1 0 0 0 1 0-1 050 0 0 0 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777  13 04311 1-1-1 1 1 0 1 0 0-1-1-1 0 1 152752 2 1-1-1       0 1 1        1076986353804220  -1  -1 7
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 023-1-1-1-1-1 2-1-120 0 0
     971                                -1-1-1-1 -1 -1 -1 -1 -1 -1  -1 -1-1 -1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1         0         0 2-1-1-1-1-1  -1-1-1  -1-1-1  -1-1-1-1  -1-1-
    1262  1  -1-1-1  -171 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
120001    169352020090815122018 220100 1 1 1-1 114-1-1-1  15732998 1 3 1 5 1 2 308011 1  1 2-1-1-1 37 22 00
      98  0000004100000        3-1490 1 1 1 2   240 2-1 9   2   1 2 1 2 1 2 57 57 57 1 0 0 1 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-140-1-1 40-1-1-110 115 2-125-1 25-1      2 5 5-1 2 3 3 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -115 1 1 1 4-1 010 -1  -1 1 4-1-1-1-1-1-1-1 4 4      -1-1       2-1-1 1 2 4-1 1 6-1 4-1 1-1 1 3-1
     486   1-1 1-1 1 1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1 2-1-1 2
     583    15732998         0         0  21855370  20896368 4 1 1-1-1 0 0 0 1 0-1 050 0 0 0 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 1 1 1 0 1 0 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 1 157186 2-1-1 3       1 1 0        21151241 770 430  -1  -1 3
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 042-1-1-1-1-1 2-1-1 0 0 0
     971                                 1 2 2 2100 30 -1 -1 -1 -1  70110 3 -1 -1 2-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1 0-1-1-1-1-1 0 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1  31714911  42787401 1 2 1 1 1 0  -6 1 0  -6 1 0  -6 1 1 0  -6 1
    1262  0  -6 1 0  -672 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
130001    205020617049244122018 122600-1 1-1-1 0-1-1 1-1         0 3 1 0 5-1 0 308111 0 -1-1-1-1-1 37 22 12
      98  9400002104000       -1-1-10-1-1-1-1  -1-1-1-1-1  -1  -1-1-1-1-1-1 -1 -1 -1-1-1-1-1-1-1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1 -1-1     -1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     389  -1-1-1-1-1-1-1-1-1 -1  -1-1-1-1-1-1-1-1-1-1-1-1      -1-1      -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     486  -1-1-1-1-1-1-1-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1-1-1-1-1
     583           0         0         0         0         0-1-1-1-1-1 1 0 1 1 0-1-1-1-1-1-1-1-1-1-1-1-1-1-
     680  1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-162341 1-1-1-1      -1-1-1               0  -1  -1  -1  -1-1
     874  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0-1-1-1-1-1-1-1-1-1-1-1
     971                                -1-1-1-1 -1 -1 -1 -1 -1 -1  -1 -1-1 -1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1068  -1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1         0         0-1-1-1-1-1-1  -1-1-1  -1-1-1  -1-1-1-1  -1-1-
    1262  1  -1-1-1  -1-1 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
140001    293863130805047122018 120100 2 1 1-1 1 6-1-1-1  72450351 1 5 4 2 2 0 209011 1  2-1-1-1-1 23 39 45
      98  7800951104000        1-1330 6-1 2 2   239 2-1 9   1   1 1 1 2 7 2 57 57 57 1 0 0 1 1 1-1-1-1-1-1-
     195  1-1-1-1-1-1-1-1-1-1 2-140-1-1 40-1-1-1-1 2-1 2-140-1 40-1      2 5 5-1 2 3 5 2-1-1-1-1-1 -1-1-1-1
     292  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 1
     389  -118 1 1 1 4-1-1-1 -1  -1 1 2-1-1-1-1-1-1-1 4 4      -1-1       2-1-1 1 2 4-1 1 6-138-121-1 1 9-1
     486   9-1 6 1 1 1 0-1-1-1-1  -1  -1  -1  -10-1      -10          -1      -10  -1-1-1-1-1-1-1-1 1 2 2 2
     583    72450351 103607696         0  72450351  70177440 8 4 1-1-1 0 0 0 1 0-1 050 0 0 1 0 1 0 0 0-1-1-
     680  1 1 0 0-1 1 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 0-1-1-1
     777  -1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 0 0 069378 1 1-1-1       0 1 1        7039458875808965  -1  -114
     874  -1-1-1-1-1 0-1-1-1-1-150505050 1 2 2 2 2 2 2 2 0 0 0 0 0 0 0-1-1-1-1-1 2-1-120 0 0
     971                                 1 2 2 2410  0 -1 -1 -1 -1 410410 1100 -1 2 1 1 1 1 1 1 1 1 1 1 1 1
    1068   1-1430 0 1 1 1 2-1 0 1 3-1 3-1 3-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1 3-1 3-1 3-1-1-1-1-1-1-1-1
    1165  -1-1-1-1-1-1-1-1-1 2-1-1 1 2-1-1 125325169 125325169 1 1 1 1 1 0  -6 1 0  -6 1 0  -6 1 1 0  -6 1
    1262  0  -6 1 0  -631 1276
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
NOTE: 142044 records were read from the infile "c:\downloads\data.dat".
      The minimum record length was 1276.
      The maximum record length was 1276.
NOTE: DATA statement used (Total process time):
      real time           0.32 seconds
      cpu time            0.26 seconds

Where are your specifications about what fields are in which columns?

If you just want to read it to write it again then just read them as character fields.  

For example if there are 200 fields then you could use formatted input to read and write them like this:

data _null_;
  infile 'data.dat' truncover;
  file 'data.csv' dsd ;
  input (var1-var200) ($20. $7. 10*$2. $10. 10*$2. ......);
  put var1-var200;
run;

But you need to know how to read the fields out of the fixed length file before you can write them into a delimited file.

[Kurt_Bremser]

So you have a fixed-width file with fixed-width columns and no delimiters; converting that to a delimited file requires knowledge of the column attributes (at least the lengths). One can try to make guesses, but with that much data there's a high risk of creating unusable garbage.

So you will have to write your data step yourself, following the specifications given in the documentation for the file.

[Patrick]

@Apolloash 

You must have a record description somewhere as else you wouldn't know what the data means. Please share this description as well. Depending on how this looks like it might be possible to use it to generate the code you need dynamically.

Any other solution without such a record description would require code which parses and analysis your text data in order to "guess" column start and end points - and this might or might not lead to a correct result.

[Apolloash]

Thank you to you all! I attached the document here! I am lost about the binary or 1-2-4 typed data. Thank you so much!

[Patrick]

OK, this attached documentation helped a lot. So what it tells you is that the data is textual and rectangular. 

You find this link in the documentation which points you not only to the data files but also to the data dictionary.

The data dictionary is not in a very friendly form but after some RegEx search&replace using Notepad++ I believe I've managed to shape the data into a form suitable to generate the input statements.

Now combining this generated input statement with all the good stuff @ChrisHemedinger posted here I've "mocked-up" some code which gets the data directly from the URL, extracts it from the zip file and reads it into a SAS dataset - and then exports the SAS dataset to a .csv. 

I'm not sure why you would want to write this .csv without the headers as you'll loose all the information "what's what" - but up to you. Just use in below code putnames=no; and you'll get your .csv without headers. 

Here the code which is fully working in my environment.

/* detect proper delim for UNIX vs. Windows */
%let delim=%sysfunc(ifc(%eval(&sysscp. = WIN),\,/));
 
/* create a name for our downloaded ZIP */
%let ziploc = %sysfunc(pathname(work))&delim.datafile.zip;
filename download "&ziploc";
 
/* Download the ZIP file from the Internet*/
proc http
 method='GET'
 url="http://thedataweb.rm.census.gov/pub/cps/basic/201701-/dec19pub.zip"
 out=download;
run;

/* Assign a fileref wth the ZIP method */
filename inzip zip "&ziploc";
 
/* Read member name from the ZIP file */
data _null_;
 fid=dopen("inzip");
 if fid=0 then stop;
 call symputx('memname',dread(fid,1));
 rc=dclose(fid);
 stop;
run;
%put memname: %nrbquote(&memname);

/* Create input statement from data dictionary */
filename layout temp;
data _null_;
  file layout;
  infile datalines dlm='|' dsd truncover;
  input vname :$32. len :$20. label :$100. FromTo :$10.;
  put 'attrib ' vname 'informat=$' len +(-1) '. ' 'label="' label +(-1) '";';
  put 'input ' vname '@;';
  datalines;
HRHHID|15|HOUSEHOLD IDENTIFIER,(Part 1)|1-15
HRMONTH|2|MONTH OF INTERVIEW|16-17
HRYEAR4|4|YEAR OF INTERVIEW|18-21
HURESPLI|2|LINE NUMBER OF THE CURRENT|22-23
HUFINAL|3|FINAL OUTCOME CODE|24-26
FILLER|2||27-28
HETENURE|2|ARE YOUR LIVING QUARTERS...|29-30
HEHOUSUT|2|TYPE OF HOUSING UNIT|31-32
HETELHHD|2|IS THERE A TELEPHONE IN THIS |33-34
HETELAVL|2|IS THERE A TELEPHONE ELSEWHERE ON |35-36
HEPHONEO|2|IS A TELEPHONE INTERVIEW ACCEPTABLE-|37-38
HEFAMINC|2|FAMILY INCOME|39-40
HUTYPEA|2|TYPE A NONINTERVIEW REASON|41-42
HUTYPB|2|TYPE B NON-INTERVIEW REASON|43-44
HUTYPC|2|TYPE C NON-INTERVIEW REASON|45-46
HWHHWGT|10|HOUSEHOLD WEIGHT|47-56
HRINTSTA|2|INTERVIEW STATUS|57-58
HRNUMHOU|2|TOTAL NUMBER OF PERSONS LIVING |59-60
HRHTYPE|2|HOUSEHOLD TYPE|61-62
HRMIS|2|MONTH-IN-SAMPLE|63-64
HUINTTYP|2|TYPE OF INTERVIEW |65-66
HUPRSCNT|2|NUMBER OF ACTUAL AND|67-68
HRLONGLK|2|LONGITUDINAL LINK INDICATOR|69-70
HRHHID2|5|HOUSEHOLD IDENTIFIER (part 2)|71-75
HWHHWTLN|2|Line Number (PULINENO) of the person whose PWSSWGT|76-77
FILLER|1||78-78
HUBUS|2|DOES ANYONE IN THIS HOUSEHOLD|79-80
HUBUSL1|2|ENTER LINE NUMBER |81-82
HUBUSL2|2|See BUSL1|83-84
HUBUSL3|2|See BUSL1|85-86
HUBUSL4|2|See BUSL1|87-88
GEREG|2|REGION|89-90
GEDIV|1|DIVISION|91-91
FILLER|1||92-92
GESTFIPS|2|FEDERAL INFORMATION |93-94
FILLER|1||95-95
GTCBSA|5|SPECIFIC METROPOLITAN CBSA CODE |96-100
GTCO|3|FIPS COUNTY CODE|101-103
GTCBSAST|1|PRINCIPAL CITY/BALANCE STATUS|104-104
GTMETSTA|1|METROPOLITAN STATUS|105-105
GTINDVPC|1|INDIVIDUAL PRINCIPAL CITY|106-106
GTCBSASZ|1|Metropolitan Area (CBSA) SIZE|107-107
GTCSA|3|Consolidated Statistical Area (CSA) FIPS CODE|108-110
FILLER|3||111-113
FILLER|2|Starting January 2014|114-117
PERRP|2|RELATIONSHIP TO REFERENCE|118-119
PEPARENT|2|LINE NUMBER OF PARENT|120-121
PRTAGE|2|PERSONS AGE |122-123
PRTFAGE|1|TOP CODE FLAG FOR AGE|124-124
PEMARITL|2|MARITAL STATUS |125-126
PESPOUSE|2|LINE NUMBER OF SPOUSE|127-128
PESEX|2|SEX|129-130
PEAFEVER|2|DID YOU EVER SERVE ON ACTIVE |131-132
FILLER|2|Starting August 2005|133-134
PEAFNOW|2|ARE YOU NOW IN THE ARMED FORCES |135-136
PEEDUCA|2|HIGHEST LEVEL OF SCHOOL |137-138
PTDTRACE|2|RACE|139 - 140
PRDTHSP|2|DETAILED HISPANIC ,ORIGIN GROUP|141-142
PUCHINHH|2|CHANGE IN HOUSEHOLD COMPOSITION|143 - 144
FILLER|2||145-146
PULINENO|2|PERSON'S LINE NUMBER|147 - 148
FILLER|2||149-150
PRFAMNUM|2|FAMILY NUMBER RECODE|151-152
PRFAMREL|2|FAMILY RELATIONSHIP RECODE|153-154
PRFAMTYP|2|FAMILY TYPE RECODE|155-156
PEHSPNON|2|HISPANIC OR NON-HISPANIC|157-158
PRMARSTA|2|MARITAL STATUS BASED ON |159-160
PRPERTYP|2|TYPE OF PERSON RECORD RECODE|161-162
PENATVTY|3|COUNTRY OF BIRTH|163-165
PEMNTVTY|3|MOTHER'S COUNTRY OF BIRTH|166-168
PEFNTVTY|3|FATHER'S COUNTRY OF BIRTH|169-171
PRCITSHP|2|CITIZENSHIP STATUS|172-173
PRCITFLG|2|CITIZENSHIP ALLOCATION FLAG|174-175
PRINUSYR|2|IMMIGRANT'S YEAR OF ENTRY|176-177
PUSLFPRX|2|LABOR FORCE INFORMATION COLLECTED|178-179
PEMLR|2|MONTHLY LABOR FORCE RECODE|180-181
PUWK|2|LAST WEEK, DID YOU DO ANY WORK|182-183
PUBUS1|2|LAST WEEK, DID YOU DO ANY|184-185
PUBUS2OT|2|DO YOU RECEIVE ANY PAYMENTS|186-187
PUBUSCK1|2|CHECK ITEM 1|188-189
PUBUSCK2|2|CHECK ITEM 2|190-191
PUBUSCK3|2|CHECK ITEM 3|192-193
PUBUSCK4|2|CHECK ITEM 4|194-195
PURETOT|2|RETIREMENT STATUS|196-197
PUDIS|2|DISABILITY STATUS|198-199
PERET1|2|DO YOU CURRENTLY WANT A JOB, EITHER |200-201
PUDIS1|2|DOES YOUR DISABILITY PREVENT YOU FROM |202-203
PUDIS2|2|DO YOU HAVE A DISABILITY THAT PREVENTS |204-205
PUABSOT|2|LAST WEEK DID YOU HAVE A JOB|206-207
PULAY|2|LAST WEEK, WERE YOU ON LAYOFF|208-209
PEABSRSN|2|WHAT IS THE MAIN REASON YOU |210-211
PEABSPDO|2|ARE YOU BEING PAID BY YOUR|212-213
PEMJOT|2|DO YOU HAVE MORE THAN ONE JOB-|214-215
PEMJNUM|2|ALTOGETHER, HOW MANY JOBS|216-217
PEHRUSL1|2|HOW MANY HOURS PER WEEK DO YOU|218-219
PEHRUSL2|2|HOW MANY HOURS PER WEEK DO YOU |220-221
PEHRFTPT|2|DO YOU USUALLY WORK 35 HOURS OR|222-223
PEHRUSLT|3|SUM OF HRUSL1 AND HRUSL2.|224-226
PEHRWANT|2|DO YOU WANT TO WORK A FULL-TIME |227-228
PEHRRSN1|2|WHAT IS YOUR MAIN REASON FOR|229-230
PEHRRSN2|2|WHAT IS THE MAIN REASON YOU DO NOT|231-232
PEHRRSN3|2|WHAT IS THE MAIN REASON YOU WORKED|233-234
PUHROFF1|2|LAST WEEK, DID YOU LOSE OR TAKE |235-236
PUHROFF2|2|HOW MANY HOURS DID YOU TAKE OFF-|237-238
PUHROT1|2|LAST WEEK, DID YOU WORK ANY |239-240
PUHROT2|2|HOW MANY ADDITIONAL HOURS|241-242
PEHRACT1|2|LAST WEEK, HOW MANY HOURS DID YOU|243-244
PEHRACT2|2|LAST WEEK, HOW MANY HOURS DID |245-246
PEHRACTT|3|SUM OF PEHRACT1 AND PEHRACT2.|247-249
PEHRAVL|2|LAST WEEK, COULD YOU HAVE WORKED|250-251
FILLER|5||252-256
PUHRCK1|2|CHECK ITEM 1|257-258
PUHRCK2|2|CHECK ITEM 2|259-260
PUHRCK3|2|CHECK ITEM 3|261-262
PUHRCK4|2|CHECK ITEM 4|263-264
PUHRCK5|2|CHECK ITEM 5|265-266
PUHRCK6|2|CHECK ITEM 6|267-268
PUHRCK7|2|CHECK ITEM 7|269-270
PUHRCK12|2|CHECK ITEM 12|271 - 272
PULAYDT|2|HAS YOUR EMPLOYER GIVEN YOU A DATE|273-274
PULAY6M|2|HAVE YOU BEEN GIVEN ANY INDICATION|275-276
PELAYAVL|2|COULD YOU HAVE RETURNED TO WORK|277-278
PULAYAVR|2|WHY IS THAT-|279-280
PELAYLK|2|EVEN THOUGH YOU ARE TO BE CALLED BACK|281-282
PELAYDUR|3|DURATION OF LAYOFF|283-285
PELAYFTO|2|FT/PT STATUS OF JOB FROM WHICH |286-287
PULAYCK1|2|CHECK ITEM 1|288-289
PULAYCK2|2|CHECK ITEM 2|290-291
PULAYCK3|2|CHECK ITEM 3|292-293
PULK|2|HAVE YOU BEEN DOING ANYTHING TO FIND |294-295
PELKM1|2|WHAT ARE ALL OF THE THINGS YOU HAVE|296-297
PULKM2|2|ANYTHING ELSE- (SECOND METHOD)|298-299
PULKM3|2|SAME AS PULKM2 (THIRD METHOD)|300-301
PULKM4|2|SAME AS PULKM2 (FOURTH METHOD)|302-303
PULKM5|2|SAME AS PULKM2 (FIFTH METHOD)|304-305
PULKM6|2|SAME AS PULKM2 (SIXTH METHOD)|306-307
PULKDK1|2|YOU SAID YOU HAVE BEEN TRYING TO |308-309
PULKDK3|2|SAME AS PULKDK2 (THIRD METHOD)|312-313
PULKDK4|2|SAME AS PULKDK2 (FOURTH METHOD)|314-315
PULKDK5|2|SAME AS PULKDK2 (FIFTH METHOD)|316-317
PULKDK6|2|SAME AS PULKDK2 (SIXTH METHOD)|318 - 319
PULKPS1|2|CAN YOU TELL ME MORE ABOUT WHAT YOU |320-321
PULKPS2|2|ANYTHING ELSE- (SECOND METHOD)|322-323
PULKPS3|2|SAME AS PULKPS2 (THIRD METHOD)|324-325
PULKPS4|2|SAME AS PULKPS2 (FOURTH METHOD)|326-327
PULKPS5|2|SAME AS PULKPS2 (FIFTH METHOD)|328-329
PULKPS6|2|SAME AS PULKPS2 (SIXTH METHOD)|330-331
PELKAVL|2|LAST WEEK, COULD YOU HAVE STARTED |332-333
PULKAVR|2|WHY IS THAT-|334-335
PELKLL1O|2|BEFORE YOU STARTED LOOKING FOR WORK,|336-337
PELKLL2O|2|DID YOU LOSE OR QUIT THAT JOB, OR WAS IT|338-339
PELKLWO|2|WHEN LAST WORKED |340-341
PELKDUR|3|DURATION OF JOB SEEKING|342-344
PELKFTO|2|FT/PT STATUS OF JOBSEEKER |345-346
PEDWWNTO|2|DO YOU CURRENTLY WANT A JOB,|347-348
PEDWRSN|2|WHAT IS THE MAIN REASON YOU WERE NOT |349-350
PEDWLKO|2|DID YOU LOOK FOR WORK AT ANY TIME |351-352
PEDWWK|2|DID YOU ACTUALLY WORK AT A JOB OR |353-354
PEDW4WK|2|DID YOU DO ANY OF THIS WORK DURING |355-356
PEDWLKWK|2|SINCE YOU LEFT THAT JOB OR |357-358
PEDWAVL|2|LAST WEEK, COULD YOU HAVE STARTED|359-360
PEDWAVR|2|WHY IS THAT-|361-362
PUDWCK2|2|SCREEN FOR DISABLED|365-366
PUDWCK3|2|FILTER FOR RETIRED|367-368
PUDWCK4|2|FILTER FOR PASSIVE JOB SEEKERS|369-370
PUDWCK5|2|FILTER FOR PASSIVE JOB SEEKERS|371-372
PEJHWKO|2|HAVE YOU WORKED AT A JOB OR BUSINESS |373-374
PUJHDP1O|2|DID YOU DO ANY OF THIS WORK IN |375-376
PEJHRSN|2|WHAT IS THE MAIN REASON YOU LEFT |377-378
PEJHWANT|2|DO YOU INTEND TO LOOK FOR WORK DURING |379-380
PUJHCK1|2|FILTER FOR OUTGOING ROTATIONS|381-382
PUJHCK2|2|FILTER FOR PERSONS GOING THROUGH THE|383-384
PRABSREA|2|REASON NOT AT WORK AND PAY STATUS |385-386
PRCIVLF|2|CIVILIAN LABOR FORCE|387-388
PRDISC|2|DISCOURAGED WORKER RECODE, |389-390
PREMPHRS|2|REASON NOT AT WORK OR HOURS AT WORK|391-392
PREMPNOT|2|MLR - EMPLOYED, UNEMPLOYED, OR NILF|393-394
PREXPLF|2|EXPERIENCED LABOR FORCE EMPLOYMENT|395-396
PRFTLF|2|FULL TIME LABOR FORCE|397-398
PRHRUSL|2|USUAL HOURS WORKED WEEKLY|399-400
PRJOBSEA|2|JOB SEARCH RECODE|401-402
PRPTHRS|2|AT WORK 1-34 BY HOURS AT WORK|403-404
PRPTREA|2|DETAILED REASON FOR PART-TIME|405-406
PRUNEDUR|3|DURATION OF UNEMPLOYMENT FOR |407-409
FILLER|2||410-411
PRUNTYPE|2|REASON FOR UNEMPLOYMENT|412-413
PRWKSCH|2|LABOR FORCE BY TIME |414-415
PRWKSTAT|2|FULL/PART-TIME WORK STATUS|416-417
PRWNTJOB|2|NILF RECODE - WANT A JOB OR OTHER NILF|418-419
PUJHCK3|2|JOB HISTORY CHECK ITEM|420-421
PUJHCK4|2|SCREEN FOR DEPENDENT NILF|422-423
PUJHCK5|2|SCREEN FOR DEPENDENT NILF|424-425
PUIODP1|2|LAST MONTH, IT WAS REPORTED THAT YOU|426-427
PUIODP2|2|HAVE THE USUAL ACTIVITIES AND DUTIES|428-429
PUIODP3|2|LAST MONTH YOU WERE REPORTED AS (A/AN)|430-431
PEIO1COW|2|INDIVIDUAL CLASS OF WORKER CODE |432-433
PUIO1MFG|2|IS THIS BUSINESS OR ORGANIZATION MAINLY|434-435
PADDING|6|Main Job I & O Codes moved to columns 856 - 863|436-441
PEIO2COW|2|INDIVIDUAL CLASS OF WORKER ON |442-443
PUIO2MFG|2|IS THIS BUSINESS OR ORGANIZATION MAINLY|444-445
PADDING|6|Second Job I & O codes moved to columns 864 - 871|446-451
PUIOCK1|2|I & O CHECK ITEM 1|452-453
PUIOCK2|2|I & O CHECK ITEM 2|454-455
PUIOCK3|2|I & O CHECK ITEM 3|456-457
PRIOELG|2|INDUSTRY AND OCCUPATION|458-459
PRAGNA|2|AGRICULTURE/|460-461
PRCOW1|2|CLASS OF WORKER|462-463
PRCOW2|2|CLASS OF WORKER|464-465
PRCOWPG|2|COW - PRIVATE OR GOVERNMENT|466-467
PRDTCOW1|2|DETAILED CLASS OF WORKER RECODE - JOB 1|468-469
PRDTCOW2|2|DETAILED CLASS OF WORKER RECODE - JOB 2|470-471
PRDTIND1|2|DETAILED INDUSTRY RECODE - JOB 1 |472-473
PRDTIND2|2|DETAILED INDUSTRY RECODE - JOB 2|474-475
PRDTOCC1|2|DETAILED OCCUPATION RECODE - JOB 1|476-477
PRDTOCC2|2|DETAILED OCCUPATION RECODE|478-479
PREMP|2|EMPLOYED PERSONS (NON-FARM|480-481
PRMJIND1|2|MAJOR INDUSTRY RECODE - JOB |1482-483
PRMJIND2|2|MAJOR INDUSTRY RECODE - JOB 2|484-485
PRMJOCC1|2|MAJOR OCCUPATION RECODE, |486-487
PRMJOCC2|2|MAJOR OCCUPATION RECODE |488-489
PRMJOCGR|2|MAJOR OCCUPATION CATEGORIES|490-491
PRNAGPWS|2|NON-AGRICULTURE, PRIVATE|492-493
PRNAGWS|2|NON-AGRICULTURE WAGE AND|494-495
PRSJMJ|2|SINGLE/MULTIPLE JOBHOLDER, RECODE|496-497
PRERELG|2|EARNINGS ELIGIBILITY FLAG|498-499
PEERNUOT|2|DO YOU USUALLY RECEIVE OVERTIME PAY,|500-501
PEERNPER|2|PERIODICITY|502-503
PEERNRT|2|(EVEN THOUGH YOU TOLD ME IT IS EASIER|504-505
PEERNHRY|2|HOURLY/NONHOURLY STATUS|506-507
PUERNH1C|4|WHAT IS YOUR HOURLY RATE OF PAY ON |508-511
PEERNH2|4|(EXCLUDING OVERTIME PAY, TIPS AND |512-515
PEERNH1O|4|OUT VARIABLE FOR HOURLY|516-519
PRERNHLY|4|RECODE FOR HOURLY RATE |520-523
PTHR|1|HOURLY PAY - TOP CODE|524-524
PEERNHRO|2|USUAL HOURS|525-526
PRERNWA|8|WEEKLY EARNINGS RECODE |527-534
PTWK|1|WEEKLY EARNINGS - TOP CODE|535-535
FILLER|4||536-539
PEERN|8|CALCULATED WEEKLY OVERTIME AMOUNT|540-547
PUERN2|8|CALCULATED WEEKLY|548-555
PTOT|1|WEEKLY OVERTIME AMOUNT - TOP CODE|556-556
FILLER|2||557-558
PEERNWKP|2|HOW MANY WEEKS A YEAR DO YOU |559-560
PEERNLAB|2|ON THIS JOB, ARE YOU A MEMBER OF A |561-562
PEERNCOV|2|ON THIS JOB ARE YOU COVERED BY A UNION |563-564
PENLFJH|2|WHEN DID YOU LAST WORK AT A JOB |565-566
PENLFRET |2|ARE YOU RETIRED FROM A JOB |567-568
PENLFACT|2|WHAT BEST DESCRIBES YOUR SITUATION AT |569-570
PUNLFCK1|2|NOT IN LABOR FORCE |571-572
PUNLFCK2|2|NOT IN LABOR FORCE|573-574
PESCHENR|2|LAST WEEK, WERE YOU ENROLLED IN A |575-576
PESCHFT|2|ARE YOU ENROLLED IN SCHOOL AS A|577-578
PESCHLVL|2|WOULD THAT BE HIGH SCHOOL, COLLEGE, |579-580
PRNLFSCH|2|NLF ACTIVITY - IN SCHOOL OR|581-582
PWFMWGT|10|FAMILY WEIGHT|583-592
PWLGWGT|10|LONGITUDINAL WEIGHT|593-602
PWORWGT|10|OUTGOING ROTATION WEIGHT|603-612
PWSSWGT|10|FINAL WEIGHT|613-622
PWVETWGT|10|VETERANS WEIGHT|623-632
PRCHLD|2|PRESENCE OF OWN CHILDREN <18 YEARS |633-634
PRNMCHLD|2|Number of own children <18 years of age |635-636
PXPDEMP1|2|ALLOCATION FLAG|637-638
PRWERNAL|2|ALLOCATION FLAG|639-640
PRHERNAL|2| ALLOCATION FLAG|641-642
HXTENURE|2|ALLOCATION FLAG|643-644
HXHOUSUT|2|ALLOCATION FLAG|645-646
HXTELHHD|2|ALLOCATION FLAG|647-648
HXTELAVL|2|ALLOCATION FLAG|649-650
HXPHONEO|2|ALLOCATION FLAG|651-652
PXINUSYR|2|ALLOCATION FLAG|653-654
PXRRP|2|ALLOCATION FLAG|655-656
PXPARENT|2|ALLOCATION FLAG|657-658
PXAGE|2|ALLOCATION FLAG|659-660
PXMARITL|2|ALLOCATION FLAG|661-662
PXSPOUSE|2|ALLOCATION FLAG|663-664
PXSEX|2|ALLOCATION FLAG|665-666
PXAFWHN1|2|ALLOCATION FLAG|667-668
PXAFNOW|2|ALLOCATION FLAG|669-670
PXEDUCA|2|ALLOCATION FLAG|671-672
PXRACE1|2|ALLOCATION FLAG|673-674
PXNATVTY|2|ALLOCATION FLAG|675-676
PXMNTVTY|2|ALLOCATION FLAG|677-678
PXFNTVTY|2|ALLOCATION FLAG|679-680
PXNMEMP1|2|ALLOCATION FLAG|681-682
PXHSPNON|2|ALLOCATION FLAG|683-684
PXMLR|2|ALLOCATION FLAG|685-686
PXRET1|2|ALLOCATION FLAG|687-688
PXABSRSN|2|ALLOCATION FLAG|689-690
PXABSPDO|2|ALLOCATION FLAG|691-692
PXMJOT|2|ALLOCATION FLAG|693-694
PXMJNUM|2|ALLOCATION FLAG|695-696
PXHRUSL1|2|ALLOCATION FLAG|697-698
PXHRUSL2|2|ALLOCATION FLAG|699-700
PXHRFTPT|2|ALLOCATION FLAG|701-702
PXHRUSLT|2|ALLOCATION FLAG|703-704
PXHRWANT|2|ALLOCATION FLAG|705-706
PXHRRSN1|2|ALLOCATION FLAG|707-708
PXHRRSN2|2|ALLOCATION FLAG|709 - 710
PXHRACT1|2|ALLOCATION FLAG|711-712
PXHRACT2|2|ALLOCATION FLAG|713-714
PXHRACTT|2|ALLOCATION FLAG|715-716
PXHRRSN3|2|ALLOCATION FLAG|717-718
PXHRAVL|2|ALLOCATION FLAG|719-720
PXLAYAVL|2|ALLOCATION FLAG|721-722
PXLAYLK|2|ALLOCATION FLAG|723-724
PXLAYDUR|2|ALLOCATION FLAG|725-726
PXLAYFTO|2|ALLOCATION FLAG|727-728
PXLKM1|2|ALLOCATION FLAG|729-730
PXLKAVL|2|ALLOCATION FLAG|731-732
PXLKLL1O|2|ALLOCATION FLAG|733-734
PXLKLL2O|2|ALLOCATION FLAG|735-736
PXLKLWO|2|ALLOCATION FLAG|737-738
PXLKDUR|2|ALLOCATION FLAG|739-740
PXLKFTO|2|ALLOCATION FLAG|741-742
PXDWWNTO|2|ALLOCATION FLAG|743-744
PXDWRSN|2|ALLOCATION FLAG|745-746
PXDWLKO|2|ALLOCATION FLAG|747-748
PXDWWK|2|ALLOCATION FLAG|749-750
PXDW4WK|2|ALLOCATION FLAG|751-752
PXDWLKWK|2|ALLOCATION FLAG|753-754
PXDWAVL|2|ALLOCATION FLAG|755-756
PXDWAVR|2|ALLOCATION FLAG|757-758
PXJHWKO|2|ALLOCATION FLAG|759-760
PXJHRSN|2|ALLOCATION FLAG|761-762
PXJHWANT|2|ALLOCATION FLAG|763-764
PXIO1COW|2|ALLOCATION FLAG|765-766
PXIO1ICD|2|ALLOCATION FLAG|767-768
PXIO1OCD|2|ALLOCATION FLAG|769-770
PXIO2COW|2|ALLOCATION FLAG|771-772
PXIO2ICD|2|ALLOCATION FLAG|773-774
PXIO2OCD|2|ALLOCATION FLAG|775-776
PXERNUOT|2|ALLOCATION FLAG|777-778
PXERNPER|2|ALLOCATION FLAG|779-780
PXERNH1O|2|ALLOCATION FLAG|781-782
PXERNHRO|2|ALLOCATION FLAG|783-784
PXERN|2|ALLOCATION FLAG|785-786
PXPDEMP2|2|ALLOCATION FLAG|787-788
PXNMEMP2|2|ALLOCATION FLAG|789-790
PXERNWKP|2|ALLOCATION FLAG|791-792
PXERNRT|2|ALLOCATION FLAG|793-794
PXERNHRY|2|ALLOCATION FLAG|795 - 796
PXERNH2|2|ALLOCATION FLAG|797-798
PXERNLAB|2|ALLOCATION FLAG|799-800
PXERNCOV|2|ALLOCATION FLAG|801-802
PXNLFJH|2|ALLOCATION FLAG|803-804
PXNLFRET|2|ALLOCATION FLAG|805-806
PXNLFACT|2|ALLOCATION FLAG|807-808
PXSCHENR|2|ALLOCATION FLAG|809-810
PXSCHFT|2|ALLOCATION FLAG|811-812
PXSCHLVL|2|ALLOCATION FLAG|813-814
QSTNUM|5|Unique household identifier. Valid only within |815-819
OCCURNUM|2|Unique person identifier. Valid only within|820-821
PEDIPGED|2|How did...get...'s high school diploma-|822-823
PEHGCOMP|2|What was the highest grade of regular |824-825
PECYC|2|How many years of college credit has...completed-|826-827
PADDING|6||828-833
PXDIPGED |2|ALLOCATION FLAG|834-835
PXHGCOMP|2|ALLOCATION FLAG|836-837
PXCYC|2|ALLOCATION FLAG|838-839
PADDING|6||840-845
PWCMPWGT|10|Composited Final Weight. Used to create|846-855
PEIO1ICD|4|INDUSTRY CODE FOR PRIMARY JOB|856-859
PEIO1OCD|4|OCCUPATION CODE FOR PRIMARY JOB.|860-863
PEIO2ICD|4|INDUSTRY CODE FOR SECOND JOB.|864-867
PEIO2OCD|4|OCCUPATION CODE FOR SECOND JOB.|868-871
PRIMIND1|2|INTERMEDIATE INDUSTRY RECODE (JOB 1)|872-873
PRIMIND2|2|INTERMEDIATE INDUSTRY RECODE (JOB 2)|874-875
PEAFWHN1|2|WHEN DID YOU SERVE-|876-877
PEAFWHN2|2|WHEN DID YOU SERVE-|878-879
PEAFWHN3|2|WHEN DID YOU SERVE-|880-881
PEAFWHN4|2|WHEN DID YOU SERVE-|882-883
PXAFEVER|2|ALLOCATION FLAG|884-885
PELNDAD|2|LINE NUMBER OF FATHER|886-887
PELNMOM|2|LINE NUMBER OF MOTHER|888-889
PEDADTYP|2|TYPE OF FATHER|890 - 891
PEMOMTYP|2|TYPE OF MOTHER|892-893
PECOHAB|2|LINE NUMBER OF COHABITING PARTNER|894-895
PXLNDAD|2|ALLOCATION FLAG|896-897
PXLNMOM|2|ALLOCATION FLAG|898-899
PXDADTYP|2|ALLOCATION FLAG|900-901
PXMOMTYP|2|ALLOCATION FLAG|902-903
PXCOHAB|2|ALLOCATION FLAG|904 - 905
PEDISEAR|2|IS-DEAF OR DOES-HAVE SERIOUS|906-907
PEDISEYE|2|IS-BLIND OR DOES-HAVE SERIOUS|908-909
PEDISREM|2|BECAUSE OF A PHYSICAL, MENTAL, OR |910-911
PEDISPHY|2|DOES-HAVE SERIOUS DIFFICULTY|912-913
PEDISDRS|2|DOES - HAVE DIFFICULTY|914-915
PEDISOUT|2|BECAUSE OF A PHYSICAL, MENTAL, OR |916-917
PRDISFLG|2|DOES THIS PERSON HAVE ANY OF |918-919
PXDISEAR|2|ALLOCATION FLAG|920-921
PXDISEYE|2|ALLOCATION FLAG|922 - 923
PXDISREM|2|ALLOCATION FLAG|924-925
PXDISPHY|2|ALLOCATION FLAG|926-927
PXDISDRS|2|ALLOCATION FLAG|928-929
PXDISOUT|2|ALLOCATION FLAG|930-931
HXFAMINC|2|ALLOCATION FLAG |932-933
PRDASIAN|2|DETAILED ASIAN RACE RECODE|934 - 935
PEPDEMP1|2|DOES THIS PERSON USUALLY HAVE ANY |936-937
PTNMEMP1|2|EXCLUDING ALL OWNERS, HOW MANY|938-939
PEPDEMP2|2|DOES THIS PERSON USUALLY HAVE ANY |940-941
PTNMEMP2|2|EXCLUDING ALL OWNERS, HOW MANY|942-943
PECERT1|2|DOES - HAVE A CURRENTLY |944-945
PECERT3|2|EARLIER YOU TOLD ME THAT YOU HAD|948-949
FILLER|45|FILLER|956-1000
;

%let data=%scan(%nrbquote(&memname),1,.);

/* Assign a fileref wth the ZIP method */
filename inzip zip "&ziploc";
/* Import a text file directly from the ZIP */
data "&data"n;
 infile inzip(&memname) lrecl=1000;
 %include layout / source2;
/* if _n_>100 then stop;*/
run;
 
/*proc print data="&data"n;*/
/*run;*/

/* export data as .csv to Unix HOME directory */
proc export data="&data"n
  outfile="~/test/&data..csv"
  dbms=csv
  replace
  ;
  putnames=yes;
/*  putnames=no;*/
run;