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 |
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
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.
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
Hi Art....Yes it worked perfectly......thanks for your help.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.