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.
... View more