topic Re: Merging multiple dataset in SAS Procedures

Merging multiple dataset

Sandhya — Tue, 15 Feb 2011 19:26:13 GMT

Hi,

Is it possible to merge multiple datasets in one proc sql.

I have 3 tables. Each of them have same id but different join_date and term_date. I want a dataset which holds the data for each id join_date and term_date.

I tried data step, but it doesn't take the multiple records on the same id value.

Thanks in advance,
Sandhya.

Re: Merging multiple dataset

sbb — Tue, 15 Feb 2011 20:34:12 GMT

It's best to share whatever code you have tried, preferably in a SAS-generated log output with all statements revealed (not just your source code window).

Also, share a data-sample, as well - both for the INPUT side and the expected/desired OUTPUT side, listed in a post-reply.

Scott Barry
SBBWorks, Inc.

Re: Merging multiple dataset

Doc_Duke — Tue, 15 Feb 2011 20:36:59 GMT

Something like this, untested code,

PROC SQL;
CREATE TABLE abc AS
SELECT a.*, b.join_date, c.term_date
FROM a, b, c
WHERE a.id=b.id AND a.id=c.id;

That will do an inner join keeping all the columns from a and just the respective dates from b and c. A left join would be similar; you can find the specifics in the SQL manual.