- data test;
- input w $ x y z;
- combvar=cats(w,x,y,z);
- cards;
- a 2 3 4
- a 2 3 4
- a 2 3 4
- b 6 9 8
- b 6 9 8
- c 6 9 4
- d 3 6 9
- f 3 6 9
- ;
- proc sql;
- create table grp as
- select *, monotonic() as grp from
- (select distinct combvar
- from test);
- quit;
- proc sql;
- create table wanted(drop=combvar) as
- select a.*, b.grp
- from test a left join grp b
- on a.combvar=b.combvar;
- quit;