creating groups

[vraj1]

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

[Loko · Accepted solution]

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;