Date: Mon, 13 Nov 2000 11:20:05 -0800
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: Multiple Datasets from SQL?
In-Reply-To: <85256996.00548E82.firstname.lastname@example.org>; from
BJohnson@HCIASACHS.COM on Mon, Nov 13, 2000 at 09:27:07AM -0600
Content-Type: multipart/signed; micalg=pgp-sha1;
on Mon, Nov 13, 2000 at 09:27:07AM -0600, Bruce Johnson (BJohnson@HCIASACHS.COM) wrote:
> Can PROC SQL produce multiple datasets? In other words, can I do the
> equivalent data step in SQL?
> DATA ONE TWO;
> SET SASDATA.MASTERFILE;
> IF HOSPID="A" THEN OUTPUT ONE;
> ELSE IF HOSPID="B" THEN OUTPUT TWO;
No. This is one task for which you'll still have to rely on a data
step, or multiple SQL queries.
Of course, I'd ask why you're segregating data by some key ID instead of
simply handling this as an analysis parameter.
Karsten M. Self <email@example.com> http://www.netcom.com/~kmself
Evangelist, Zelerate, Inc. http://www.zelerate.org
What part of "Gestalt" don't you understand? There is no K5 cabal