DATA Step, Macro, Functions and more

change variable with list of items to variable with single item

Accepted Solution Solved
Reply
Regular Contributor
Posts: 199
Accepted Solution

change variable with list of items to variable with single item

Hi,
I have a variable with lists of items in it.
For example,
a,b
a,b,e
b
e,f,g,h

Does anyone know how to create a new variable with each item having its own row like this:
a
b
a
b
e
b
e
f
g
h

Thank you.


Accepted Solutions
Solution
‎05-17-2013 03:48 PM
Super User
Posts: 11,343

Re: change variable with list of items to variable with single item

The basic approach is to parse the string and for each piece extract a value and execute an Output statement. However the actual content may cause issues but for your example, assuming the variable is named Text some thing like this in a data step:

Data want;

     set have;

length ShortText $ 10; /* or some value large enough to capture the longest substring in Text*/

Do i = 1 to Countw(Text,',');

     ShortText=scan(text,i,',');

     output;

End;

drop i;

Run;

View solution in original post


All Replies
Solution
‎05-17-2013 03:48 PM
Super User
Posts: 11,343

Re: change variable with list of items to variable with single item

The basic approach is to parse the string and for each piece extract a value and execute an Output statement. However the actual content may cause issues but for your example, assuming the variable is named Text some thing like this in a data step:

Data want;

     set have;

length ShortText $ 10; /* or some value large enough to capture the longest substring in Text*/

Do i = 1 to Countw(Text,',');

     ShortText=scan(text,i,',');

     output;

End;

drop i;

Run;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation