DATA Step, Macro, Functions and more

how to extract particular string from the variable

Accepted Solution Solved
Reply
Regular Contributor
Posts: 200
Accepted Solution

how to extract particular string from the variable

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


Accepted Solutions
Solution
‎04-08-2018 12:48 PM
PROC Star
Posts: 499

Re: how to extract particular string from the variable

[ Edited ]

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;

 

View solution in original post


All Replies
Solution
‎04-08-2018 12:48 PM
PROC Star
Posts: 499

Re: how to extract particular string from the variable

[ Edited ]

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;

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation