re: counting by two group variables

Solved
Regular Contributor
Posts: 245

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: 8,145

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

All Replies
Posts: 1,309

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?

Solution
‎03-31-2017 11:18 AM
PROC Star
Posts: 8,145

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: 245

Re: re: counting by two group variables

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

☑ This topic is solved.