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
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.