topic Re: how to extract particular string from the variable in SAS Programming

how to extract particular string from the variable

vraj1 — Sun, 08 Apr 2018 10:08:48 GMT

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

Re: how to extract particular string from the variable

kiranv_ — Sun, 08 Apr 2018 13:05:23 GMT

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;