topic Re: Read multiple line into one single column data in SAS Programming

Read multiple line into one single column data

Riteshdell — Fri, 29 Sep 2017 09:36:29 GMT

hello ALl,

I am looking for a soluition .

I am reading a pipe seperator csv file.

for one column data is going to 2nd line and adn 3rd line as well.

and in the 4th line next PIPE (|) seperator is there to divide other column data.

Please tell me how can I read, in below example for city column I want to read data start from london to china untill it is not getting next pipe symbol.

example :

name|id|city|date

john|123|london

sweden - germeny - india

pakistan china

|26jul2017

Re: Read multiple line into one single column data

error_prone — Fri, 29 Sep 2017 10:14:09 GMT

Have a look at https://communities.sas.com/t5/SAS-Procedures/Extract-data-from-a-unfriendly-text-file/m-p/399239#M66609.

Re: Read multiple line into one single column data

Ksharp — Fri, 29 Sep 2017 14:25:47 GMT

data have;
infile cards truncover;
input have $200.;
length x $ 2000;
retain x;
x=catx(' ',x,have);
if countc(x,'|')=3 then do; 
 name=scan(x,1,'|');
 id=scan(x,2,'|');
 city=scan(x,3,'|');
 date=scan(x,4,'|');
 output;
 call missing(x);
end;
drop x have;
cards;
name|id|city|date
john|123|london
sweden - germeny - india
pakistan china
|26jul2017
;
run;