re: counting by two group variables

[twildone]

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

[mkeintz]

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.

[art297 · Accepted solution]

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

[twildone]

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