I have a data set that looks something like this: data have;
infile datalines delimiter=',';
input IDnumber String $50.;
datalines;
2477,Cat Dog A blue car
2431,Cat Fish Yelllow Submarine
;
run; I need to extract each data item from the string to one row so that i get this: data want;
infile datalines delimiter=',';
input IDnumber String $50.;
datalines;
2477,Cat
2477,Dog
2477,A blue car
2431,Cat
2431,Fish
2431,Yelllow Submarine
;
run; The text will sometimes be split by a single word, other times several words constitute one phrase, and one phrase can sometimes start with a capital letter followed by a small letter in the next word, but othertimes it has capital letters in both words of one phrase, so I cannot use regexp or the like to do a sort of conditional do loop or array. I basically need to hardcode it so something like this, but cant quite wrap my head around the right syntax: data try;
set have;
do ... ;
if index(String,'Cat') > 0 then output Phrase = 'Cat' ;
if index(String,'Dog') > 0 then output Phrase = 'Dog' ;
if index(String,'A blue car') > 0 then output Phrase = 'A blue car' ;
if index(String,'Fish') > 0 then output Phrase = 'Fish' ;
if index(String,'Yellow submarine') > 0 then output Phrase = 'Yellow submarine' ;
;
end;
run;
... View more
