topic creating groups in SAS Programming

creating groups

vraj1 — Mon, 21 Mar 2016 12:55:58 GMT

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 — Mon, 21 Mar 2016 13:10:07 GMT

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;