Hello
For the following data set I want to add a new column.
For first customer ID it will get value 1
For second customer ID it will get value 2
So the new column will get values:
1
1
1
2
2
2
Data tbl1;
input ID x;
cards;
123456 2
123456 4
123456 6
212321 8
212321 10
212321 12
;
run;
Do like this
data want;
set tbl1;
by ID notsorted;
if first.ID then rank+1;
run;
Do like this
data want;
set tbl1;
by ID notsorted;
if first.ID then rank+1;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.