For the best of both worlds, try
create view setvw as
select * from set1,set2 ....
proc print data=setvw;
On Thu, 3 Jan 2002 18:33:05 -0500, Robert Abelson <rabelson@KAI-
>You can print the result of a merge of two datasets using PROC SQL.
> select *
> from set1, set2
> where set1.id = set2.id;
>This will print, but it will probably not look so great.
>6001 Montrose Rd.
>Rockville, MD 20852
>> -----Original Message-----
>> From: Kemp, Michael [SMTP:Michael.Kemp@GS.COM]
>> Sent: Thursday, January 03, 2002 6:24 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: Implicit merge on PROC
>> Is it possible to merge two (or more datasets) using a PROC statement?
>> For example,
>> If you want to do a proc print on two separate datasets, must you always
>> a data step prior to the PROC that merges the data, and then run the PROC
>> against the resultant dataset? Or, is there a way to do something with
>> effect of:
>> 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.
>> Mike Kemp