topic Re: re: counting by two group variables in SAS Programming

re: counting by two group variables

twildone — Fri, 31 Mar 2017 14:21:08 GMT

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

Re: re: counting by two group variables

mkeintz — Fri, 31 Mar 2017 14:23:27 GMT

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.

Re: re: counting by two group variables

art297 — Fri, 31 Mar 2017 14:56:41 GMT

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

Re: re: counting by two group variables

twildone — Fri, 31 Mar 2017 15:17:58 GMT

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