SAS Function Help

[mounikag]

Hi All,

I need help in programming part: Data looks as below:

Rawdata:

Subject    category

101         LEFT DELTOID MUSCLE

101         RIGHT DELTOID MUSCLE

So  I need a output as below:

Output dataset:

Subject     category1

101           DELTOID MUSCLE

101           DELTOID MUSCLE

So which character function I need to use to get only 'deltoid muscle' string in the output. Please provide your inputs. TIA

[novinosrin · Accepted solution]

data have;
input Subject $3.    category & $20.;
cards;
101         LEFT DELTOID MUSCLE
101         RIGHT DELTOID MUSCLE
;

data want;
 set have;
 length need $100;
 Need=substr(category,anyspace(strip(category))+1);
run;

[mounikag]

Thanks . Your answer helped me.