## Increment based on custid

Solved
Frequent Contributor
Posts: 140

# Increment based on custid

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

Accepted Solutions
Solution
‎10-09-2014 01:36 AM
Posts: 1,147

## Re: Increment based on custid

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

Thanks,
Jag

All Replies
Solution
‎10-09-2014 01:36 AM
Posts: 1,147

## Re: Increment based on custid

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

Thanks,
Jag
Regular Contributor
Posts: 168

## Re: Increment based on custid

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

Super User
Posts: 10,218

## Re: Increment based on custid

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
🔒 This topic is solved and locked.