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
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;
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;
Thanks . Your answer helped me.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.