how to extract particular string from the variable

[vraj1]

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

[kiranv_ · Accepted solution]

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;