I have the following dataset called "Agearank" containing 2,042 observations. I also have another dataset called "Agea" containing 28,031 observations. I would like to join "Agea" into "Agearank" by IN_PUMA_ID. My goal is to attach the variable PWPUMAS (i.e., Super-PUMA of work) in the "Agea" dataset to the "Agearank" dataset. In the newly created dataset (e.g., new), I would only like to have 2,042 observations based on the "Agearank" dataset. How should I write the SAS code? Thank you.
... View more