topic Re: merging two dataset in SAS Programming

merging two dataset

pras3 — Fri, 21 Mar 2014 11:31:03 GMT

Hi,

I can't seem to merge the attached dataset using the following code.

There appears no errors on the log file but there is no data in the merge file.

proc sort data=G4;by TIC Fyear; run;

proc sort data=G5; by TIC Fyear;run;

data G6A;merge G4(in=x) G5(in=y); by TIC Fyear;if x=y;run;

Thank You

Puspa

Re: merging two dataset

data_null__ — Fri, 21 Mar 2014 11:43:33 GMT

I don't see any matching FYEAR; so X can never equal Y.

Re: merging two dataset

RichardinOz — Fri, 21 Mar 2014 12:26:09 GMT

When you do have matching data you should consider rephrasing your if condition:

if x and y;

This is equivalent to

if x = 1 and y = 1 ; /* ie both true */

The condition x=y is also met when both are false, an unwanted case. Sure, the merge process takes care of that but it is a sloppy statement in this context.

Richard