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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.