Breaking News: Grepper is joining You.com. Read the official announcement!

sas create group id by multiple columns

Tiange Ye answered on April 28, 2022 Popularity 2/10 Helpfulness 1/10

answer sas create group id by multiple columns

sas create group id by multiple columns

Comment

proc sort data=sashelp.cars out=cars; 
  by Make DriveTrain Cylinders;
run;

data cars;
  set cars;
  by Make DriveTrain Cylinders;

  if first.Cylinders then grp_id + 1;

  * this answer gives you bonus information ! ;
  if first.Cylinders 
    then seq_in_group = 1; 
    else seq_in_group + 1;
run;

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: group multiple-columns sas unique-id whatever

Link to this answer
Share Copy Link