Wow! I can't believe how hard this is with SAS. How do you remove all duplicated rows?
For example, if I have the following data set:
OBS Letter
1 A
2 A
3 A
4 B
5 C
6 D
I want a data set that removes all the As. Like the following:
OBS Letter
1 B
2 C
3 D
This should be something easy to do. But I find it almost impossible with SAS.
For example, if I have the following data set:
OBS Letter
1 A
2 A
3 A
4 B
5 C
6 D
I want a data set that removes all the As. Like the following:
OBS Letter
1 B
2 C
3 D
This should be something easy to do. But I find it almost impossible with SAS.