Help using Base SAS procedures

Creating a subset of observations

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

Creating a subset of observations

Hello everyone,

I have two datasets which has the same variable (Uni_Id). I want to create a subset of dataset1 such that the new subset will contain the observations whose uni_id values are equal to the values for this variable in the other dataset, dataset2.

I appreciate any suggestion.


Accepted Solutions
Solution
‎02-20-2015 11:54 AM
Super Contributor
Posts: 266

Re: Creating a subset of observations

Do  you want to keep the vars in both data sets?  I will assume  you do.  If you want only those observations where the ID is the same in both datasets:

proc sql;

create table join1 as

select a.*, b.* from dataset1 as a

inner join dataset2 as b

on a.Uni_id=b.Uni_id

quit:

You will get a warning saying that Uni_id appears in both data sets and it will the value of Uni_id in dataset1

View solution in original post


All Replies
Solution
‎02-20-2015 11:54 AM
Super Contributor
Posts: 266

Re: Creating a subset of observations

Do  you want to keep the vars in both data sets?  I will assume  you do.  If you want only those observations where the ID is the same in both datasets:

proc sql;

create table join1 as

select a.*, b.* from dataset1 as a

inner join dataset2 as b

on a.Uni_id=b.Uni_id

quit:

You will get a warning saying that Uni_id appears in both data sets and it will the value of Uni_id in dataset1

Contributor
Posts: 65

Re: Creating a subset of observations

Thank you.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 216 views
  • 0 likes
  • 2 in conversation