topic Re: Increment based on custid in SAS Programming

Increment based on custid

sas_Forum — Thu, 09 Oct 2014 05:00:44 GMT

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 — Thu, 09 Oct 2014 05:36:57 GMT

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 — Thu, 09 Oct 2014 06:02:10 GMT

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

Kurt_Bremser — Thu, 09 Oct 2014 06:15:39 GMT

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