DATA Step, Macro, Functions and more

Read multiple line into one single column data

Reply
Contributor
Posts: 73

Read multiple line into one single column data

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

 

 

Regular Contributor
Posts: 226

Re: Read multiple line into one single column data

Posted in reply to Ritesh_dellvostro
Super User
Posts: 10,848

Re: Read multiple line into one single column data

Posted in reply to Ritesh_dellvostro
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;
Ask a Question
Discussion stats
  • 2 replies
  • 178 views
  • 0 likes
  • 3 in conversation