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
I don't see any matching FYEAR; so X can never equal Y.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.