Increment based on custid

[sas_Forum]

data l;
input custid sale;
cards;
a 1
a 23
a 45
b 4
b 67
b 67
run;

I want to get the number for incriment by 1 based on custid as number should incremnt

Output :

custid  sale  Cust no
a  1 1
a  23 2
a  45 3
b 4 1
b  67 2
b  67 3

[Jagadishkatam · Accepted solution]

Please try

proc sort data=l;

by custid sale;

run;

data want;

set l;

by custid sale;

retain custno 0;

if first.custid then custno=1;

else custno+1;

run;

Thanks,

Jag

[RamKumar]

Code is fine. It is also producing the desired result without retain statement.

[Kurt_Bremser]

As soon as you use the construct variable + x (instead of variable = variable + x), the variable is automatically retained.