Improve company productivity with a Business Account.Sign Up

x
?
Solved

Join tables in SAS

Posted on 2007-11-21
2
Medium Priority
?
4,303 Views
Last Modified: 2013-11-16
I have 2 tables: table 1 one with a list of IDs and table 2 with a smaller list of IDs, which are all also in table 1. I want to merge/join the 2 tables in such a manner that I keep all the IDS in table 1, but not the IDS that are in both table 1 and 2. What kind of join do I need to do?
0
Comment
Question by:migiurgiu
  • 2
2 Comments
 
LVL 1

Expert Comment

by:wolfen351
ID: 20332946
proc sql;
  create table3 as
  select * from table1 where id not in (select id from table2) Data
quit;
0
 
LVL 1

Accepted Solution

by:
wolfen351 earned 200 total points
ID: 20332954
data table3;
  merge table1(in=a) table2(in=b);
  by id;
  if a and not b;
quit;
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What we learned in Webroot's webinar on multi-vector protection.
Are you working to mount the dismounted Exchange 2013 database? Then the best course of action is to analyze the causes of Database issue, their probable solutions and decide for the appropriate course of action.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question