topic Re: Merging datasets without using MERGE statement in SAS Programming

Merging datasets without using MERGE statement

kaushiklu — Sun, 03 Jul 2011 14:59:49 GMT

Is there any method to merge two datasets without using MERGE statement . it might be simple question . but as I am new to SAS , Please provide the information . thanks!!

Merging datasets without using MERGE statement

Ankitsas — Sun, 03 Jul 2011 19:24:44 GMT

Friend,

Use proc sql using inner join instead of merge statement...

Ankit

Re: Merging datasets without using MERGE statement

art297 — Mon, 04 Jul 2011 18:27:20 GMT

Depends on what you are trying to do. Does the following approximate what you are calling merging?

data one;

input x;

cards;

;

data two;

input y $;

cards;

;

data both;

set one;

set two;

run;

HTH,

Art

Re: Merging datasets without using MERGE statement

mojerry2 — Tue, 05 Jul 2011 05:54:52 GMT

Hi, You can use the proc sql statement to join your two tables.

the inner join is the match join. You'll need your id in the two tables to have it as output.

the left or right join permitts to join a source table with an other and one of the tables is used as reference.

the full join just tries to match your two tables. it's the less used.

Merging datasets without using MERGE statement

Peter_C — Mon, 11 Jul 2011 14:14:27 GMT

when you want to merge data, and since MERGE is obvious, why would you resist using it ? ^

Re: Merging datasets without using MERGE statement

dhana — Tue, 12 Jul 2011 13:40:55 GMT

Hi,

There are lot of methods available for merging 2 datasets. But which method you use is based on the type of data and number of observation it has.

1. PROC SQL;

SELECT VAR1,VAR2,T1.VAR3,VAR4,VAR5

FROM TABLE1 AS T1,TABLE2 AS T2

WHERE T1.VAR3=T2.VAR1;

QUIT;

In PROC SQL itself there are many methods available (Inner Join, Left Join, Right Join) and apart from that you can use SET operators (EXCEPT,INTERCEPT, UNION) to merge datasets. (But each one serve different purpose).

2. SET statement

a) DATA dataset-name;

SET sas-dataset;

RUN;

b) DATA dataset-name;

SET sas-dataset;

SET sas-dataset KEY=index-name;

RUN;

When you specify the index name in the KEY=option, processing changes from sequential to direct access, and SAS reads only the observation that satisfies the lookup.

Hope this answers your question.

Thanks

Dhanasekaran R