DATA Step, Macro, Functions and more

creating groups

Accepted Solution Solved
Reply
Regular Contributor
Posts: 160
Accepted Solution

creating groups

i want to create a group which has A B C D in the last letter of word as one group and E, F, G H as other group in a variable

var2

DRA-04U-A

DRA-099Y-B

DRd-989-E

 

in this case i want to create a new variable which has A,B in one group and E in another group and so on

 


Accepted Solutions
Solution
‎03-21-2016 09:19 AM
Super Contributor
Posts: 308

Re: creating groups

Hello,

 

if the last letter in your var variable determines the group then you can get it like this:

 

data have;
infile datalines;
input var2 $50.;
datalines;
DRA-04U-A
DRA-099Y-B
DRd-989-E
;

data want;
set have;
group=scan(var2,-1,"-");
run;

View solution in original post


All Replies
Solution
‎03-21-2016 09:19 AM
Super Contributor
Posts: 308

Re: creating groups

Hello,

 

if the last letter in your var variable determines the group then you can get it like this:

 

data have;
infile datalines;
input var2 $50.;
datalines;
DRA-04U-A
DRA-099Y-B
DRd-989-E
;

data want;
set have;
group=scan(var2,-1,"-");
run;

☑ This topic is solved.

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

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