I have raw data consisting of a long string of numbers separated by semicolons. Like this:
1; 2; 3; 4; 5; …
I don’t know the number of values in advance.
I’d like to read these in using a data step and create one observation per value.
I’ve looked at several examples of using the input statement, but nothing works the way I would like it to.
Anyone have a suggestion?
You can use double trailing @ to read multiple obs from one record.
data a;
infile cards4 dsd dlm=';';
input v @@;
cards4;
1; 2; 3; 4; 5;
;;;;
run;
You can use double trailing @ to read multiple obs from one record.
data a;
infile cards4 dsd dlm=';';
input v @@;
cards4;
1; 2; 3; 4; 5;
;;;;
run;
That's a good approach. You might find it necessary to include blanks as delimiters as well:
dlm='; '
This is very cool, thanks. I had forgotten all about @@.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.