DATA Step, Macro, Functions and more

re: counting by two group variables

Accepted Solution Solved
Reply
Regular Contributor
Posts: 222
Accepted Solution

re: counting by two group variables

Hi....I am trying to create a variable that has the incremental count by ID and Month_Year. The problem I think has to do with the duplication of the grouping variables. Any suggestion on how to handle this...thanks.

 

Getting:

ID Month_Year Order1
2334 March 2015 1
2334 March 2015 2
2334 March 2015 3
2334 April 2015 1
2334 April 2015 2
2334 April 2015 3
2334 May 2015 1
2334 May 2015 2
2334 May 2015 3
2566 March 2015 1
2566 March 2015 2
2566 March 2015 3
2566 April 2015 1
2566 April 2015 2
2566 April 2015 3
2566 May 2015 1
2566 May 2015 2
2566 May 2015 3

 

 

Want:

ID Month_Year Order1
2334 March 2015 1
2334 March 2015 1
2334 March 2015 1
2334 April 2015 2
2334 April 2015 2
2334 April 2015 2
2334 May 2015 3
2334 May 2015 3
2334 May 2015 3
2566 March 2015 1
2566 March 2015 1
2566 March 2015 1
2566 April 2015 2
2566 April 2015 2
2566 April 2015 2
2566 May 2015 3
2566 May 2015 3
2566 May 2015 3

Accepted Solutions
Solution
‎03-31-2017 11:18 AM
PROC Star
Posts: 7,364

Re: re: counting by two group variables

If you are just trying to calculate the values for group then I think that the following does what you want:

 

data want;
  set have;
  by id month_year notsorted;
  if first.id then group=1;
  else if first.month_year then group+1;
run;

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Valued Guide
Posts: 797

Re: re: counting by two group variables

1. what data are you starting with?

2. what is your current program?

3. what is the rule you wish to use to take the input and make the desired output?

 

we are not mind readers.

Solution
‎03-31-2017 11:18 AM
PROC Star
Posts: 7,364

Re: re: counting by two group variables

If you are just trying to calculate the values for group then I think that the following does what you want:

 

data want;
  set have;
  by id month_year notsorted;
  if first.id then group=1;
  else if first.month_year then group+1;
run;

Art, CEO, AnalystFinder.com

 

Regular Contributor
Posts: 222

Re: re: counting by two group variables

Hi Art....Yes it worked perfectly......thanks for your help.

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 123 views
  • 0 likes
  • 3 in conversation