Solved: Re: re: counting by two group variables

twildone · Posted 03-31-2017 10:21 AM

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

art297 · Posted 03-31-2017 10:56 AM

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

mkeintz · Posted 03-31-2017 10:23 AM

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.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

art297 · Posted 03-31-2017 10:56 AM

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 · Posted 03-31-2017 11:17 AM

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

re: counting by two group variables

Re: re: counting by two group variables

Re: re: counting by two group variables

Re: re: counting by two group variables

Re: re: counting by two group variables

Click image to register for webinar

Classroom Training Available!