Re: how to read in really messy data like this?

SR71Blackbird — Wed, 21 Mar 2012 09:48:37 GMT

Hello S Rvauri,

for SAS programs as member in a PDS-file you have to use 80 chars of length, but for simple data in a flatfile you can use much more, I think about 32000 or so. Just try to allocate an extra file for the data on z/OS.

So "infile cards" won't be the preferred way, you should reference an external flat file.

Re: how to read in really messy data like this?

SR71Blackbird — Wed, 21 Mar 2012 09:07:53 GMT

Hello ZRick,

just try this:

filename mydata "path to data\data.txt";

data mydata(drop=row i);
length ID $20 Date $15 Price 8;
infile mydata truncover lrecl=256;
input @1 row $256.;
ID = scan(row,1,' ');
i=2;
do while (Date ne '' or i=2);
Date = scan(row,i,' ');
if index(scan(row,i+1,' '),'/') then do;
       Price = .;
     i = i + 1;
end;
else do;
    Price = input(scan(row,i+1,' '),12.);
    if Price < 90 then Price = Price / 100;
     i = i + 2;
end;
if Date ne '' then output;
end;
run;

Just remember that the parameter "lrecl=256" should be as long or longer than the longest row and the informat to variable "row" should be as long as this parameter.

SR71Blackbird Tracker

Re: how to read in really messy data like this?

Re: how to read in really messy data like this?