topic Re: How do I import CSV file with field containing a list of values? in SAS Programming

How do I import CSV file with field containing a list of values?

kaziumair — Tue, 23 Feb 2021 09:56:38 GMT

Hi , I have to import a CSV file as a SAS Dataset . The CSV file has various fields which have list of values separated by a delimiter. For example there is a variable citizenship with values like French;Spanish .

I am unable to figure out how to read this list using the input statement in data step.

Attaching a dummy CSV file as an example.

Re: How do I import CSV file with field containing a list of values?

Kurt_Bremser — Tue, 23 Feb 2021 10:24:05 GMT

Read it into a temporary variable, and use a DO loop to split the data into observations:

data want;
infile
  "/folders/myfolders/test.csv"
  dsd
  truncover
  firstobs=2
;
input uid $ _fav_color :$100.;
length fav_color $20;
do i = 1 to countw(_fav_color,"~");
  fav_color = scan(_fav_color,i,"~");
  output;
end;
drop _fav_color;
run;

Re: How do I import CSV file with field containing a list of values?

kaziumair — Tue, 23 Feb 2021 10:47:13 GMT

Thank you for your help.