I have a variable which has data like
IE_INCL001G_9
IE_INCL001G_4
IE_INCL001G_19
IE_EXCL001G_3
IE_EXCL001G_1
I need data like INCL_09,.......EXCL_01, so need to extract INCL and EXCL and numbers at last with format as 2. means 9 should be 09.
any help please
one way to do this
data have;
input var $20.;
datalines;
IE_INCL001G_9
IE_INCL001G_4
IE_INCL001G_19
IE_EXCL001G_3
IE_EXCL001G_1
;
data want;
set have;
newvar= cats(substr(scan(var,2,"_"),1,4),put(input(scan(var,3,"_"),2.),z2.));
run;
one way to do this
data have;
input var $20.;
datalines;
IE_INCL001G_9
IE_INCL001G_4
IE_INCL001G_19
IE_EXCL001G_3
IE_EXCL001G_1
;
data want;
set have;
newvar= cats(substr(scan(var,2,"_"),1,4),put(input(scan(var,3,"_"),2.),z2.));
run;
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.