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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.