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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.