BookmarkSubscribeRSS Feed
teja5959
Fluorite | Level 6

data have 

101 1-Burning

102 1-Burning2-Itching

103 1-Burning2-Itching3- swelling

 

I want data 

101   Burning

102   Burning

102   Itching

103   Burning

103   Itching

103   swelling

 

1 REPLY 1
SASKiwi
PROC Star

Here's one way:

data have; 
input @1 ID $3. Symptom $30.;
datalines;
101 1-Burning
102 1-Burning2-Itching
103 1-Burning2-Itching3- swelling
;
run;

data want;
  drop i words Symptom;
  set have;
  words = countw(Symptom, '-123 ');
  do i = 1 to words;
    Symptom_Single = scan(Symptom,i, '-123 ');
    output;
  end;
run;

Please post your data like I've done in a DATALINES statement in the future to save us time in answering.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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