BookmarkSubscribeRSS Feed
teja5959
Obsidian | Level 7

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.

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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