Hello,
I need some help with a proc SQL problem. Take the sample data below:
Table 1
Code Description
1 X
2 Y
3 Z
Table 2
Code ID
2 a
3 b
4 c
So I want to pull all the observations from Table 2 that have a matching Code from Table 1 (so this would be Code 2 and Code 3).
Is there a way to do this in SAS (I presume it is easiest with proc SQL but if it works with a data step that is great too)
Thanks!