topic Re: SAS Function Help in SAS Programming

SAS Function Help

mounikag — Thu, 17 Sep 2020 21:04:36 GMT

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

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

Re: SAS Function Help

novinosrin — Thu, 17 Sep 2020 21:11:02 GMT

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;

Re: SAS Function Help

mounikag — Thu, 17 Sep 2020 21:45:24 GMT

Thanks . Your answer helped me.