Date: Thu, 3 Jan 2002 16:36:10 -0700
Reply-To: Kenneth Moody <KennethMoody@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Kenneth Moody <KennethMoody@FIRSTHEALTH.COM>
Subject: Re: Implicit merge on PROC
Content-Type: text/plain; charset=us-ascii
You can get the effect by using a data step view. For example,
DATA virtual / view=virtual;
merge set1 set2; by id;
proc print data=virtual;
The view is not executed until it is referenced in the proc print step,
and it is not
necessary to physically create the merged dataset.
First Health, Metrics Department
>>> "Kemp, Michael" <Michael.Kemp@GS.COM> 01/03/02 03:23PM >>>
Is it possible to merge two (or more datasets) using a PROC statement?
If you want to do a proc print on two separate datasets, must you
a data step prior to the PROC that merges the data, and then run the
against the resultant dataset? Or, is there a way to do something with
PROC PRINT DATA=SET1 MERGE SET2 BY ID;
If this were possible, it would seem to me to be much more efficient.
Thanking you in advance.