merging two dataset

Reply
Occasional Contributor
Posts: 5

merging two dataset

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

Attachment
Attachment
Respected Advisor
Posts: 3,799

Re: merging two dataset

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

Super Contributor
Posts: 644

Re: merging two dataset

Posted in reply to data_null__

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


Ask a Question
Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 3 in conversation