Hi All,
The solutions of the community have always helped me and saved lot of time too. Here I am again with another problem. It is looking very simple but I am not able to do it by simple program.
My input is as follows
| 1 | A |
| 1 | A |
| 1 | B |
| 2 | A |
| 2 | A |
| 2 | A |
| 2 | B |
| 2 | B |
| 3 | A |
| 3 | B |
| 3 | C |
| 3 | C |
| 3 | C |
| 3 | C |
| 4 | D |
| 4 | D |
| 4 | E |
| 5 | A |
| 5 | B |
| 5 | C |
and I am looking for output where I get unique values of sub-group as follows
| 1 | A |
| 1 | B |
| 2 | A |
| 2 | B |
| 3 | A |
| 3 | B |
| 3 | C |
| 4 | D |
| 4 | E |
| 5 | A |
| 5 | B |
| 5 | C |
Thanks in advance !
Like this?
proc sort nodupkey;
by VAR1 VAR2;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.