topic Reading by delimiter in SAS Procedures

Reading by delimiter

akberali67 — Wed, 04 Apr 2012 07:10:19 GMT

Is there a way to readin a raw file by delimiter or is a line by line read-in the only option. Because I have split lines with quite weird scenarios.

A B C

1 2 3

3 6

1 5

It should have been

A B C

1 2 3

1 3 6

1 5 8

Please help!

Reading by delimiter

manojinpec — Wed, 04 Apr 2012 08:49:02 GMT

Not sure whether it is possible or not..

Reading by delimiter

Hima — Wed, 04 Apr 2012 11:08:50 GMT

data have;
input a b c;
cards;
1               2                3
1
3               6
1               5
8
;
run;

proc print; run;

Output:

Obs a b c

                                        1     1    2    3
                                        2     1    3    6
                                        3     1    5    8

Re: Reading by delimiter

Ksharp — Fri, 06 Apr 2012 08:47:38 GMT

I think you should post some more sample data to clarify your question.

filename x 'c:\x.txt';
data want(keep=a b c);
 infile x end=last;
 input;
 length row $ 256 ;
 retain row;
 row=catx(' ',row,_infile_);
 if countw(row)=3 then do;
                         a=scan(row,1);b=scan(row,2);c=scan(row,3);
                         output;
                         call missing(row);
                        end;
  else if last then do;
                         a=scan(row,1);b=scan(row,2);c=scan(row,3);
                         output;
                     end;
run;

Ksharp