merging two dataset

[pras3]

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

[data_null__]

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

[RichardinOz]

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