For a raw data file containing data as shown below:
1 2 3 4
5 6 7 8 9
20 32
43 41 12 13 15 18 10
to be read with an infile statement, with 3 variables like so:
data test;
infile 'c:\location';
input x y z;
run;
so I want the final data set to look like:
1 2 3
4 5 6
7 8 9
20 32 43
41 12 13
15 18 10
====
All options about using carriage return to align the raw data set is out because there are about 42,000 records. Also, if it helps, I know the total length of each observation.