DATA Step, Macro, Functions and more

Increment based on custid

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 140
Accepted Solution

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
Trusted Advisor
Posts: 1,137

Re: Increment based on custid

Posted in reply to sas_Forum

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

Thanks,
Jag

View solution in original post


All Replies
Solution
‎10-09-2014 01:36 AM
Trusted Advisor
Posts: 1,137

Re: Increment based on custid

Posted in reply to sas_Forum

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

Thanks,
Jag
Regular Contributor
Posts: 168

Re: Increment based on custid

Posted in reply to Jagadishkatam

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

Super User
Posts: 7,868

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
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 195 views
  • 0 likes
  • 4 in conversation