Date:         Wed, 3 May 2000 11:33:37 +1000
Reply-To:     Philip_Crane@WORKCOVER.VIC.GOV.AU
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Philip Crane <Philip_Crane@WORKCOVER.VIC.GOV.AU>
Subject:      Re: How to use the output from Proc SQL
Comments: To: oliver <oliver@AGYINC.COM>
Content-type: text/plain; charset=us-ascii

OLiver

You need to create a sas dataset like this

proc sql;
       create table newdata as
       select
        avg(t0)/avg(d0) as mmt0,
   avg(t1)/avg(d1) as mmt1,
    from oliSAS.BV2TC2H1;
    where cloneID like 'empty';

You can then use the dataset newdata like this

proc print data=newdata;

Philip




oliver <oliver@AGYINC.COM> on 03/05/2000 11:19:54 AM

Please respond to oliver <oliver@AGYINC.COM>



 To:      SAS-L@LISTSERV.UGA.EDU

 cc:



 Subject: How to use the output from Proc SQL







Hi, SAS Expert
Proc SQL is only the middle of my process. However,
I can not figure out how to use the out put from Proc SQL in my later
data step.
For example:  How can I use the new variable I just generate "mmt0" in
the later time?
   proc sql;
   select
   avg(t0)/avg(d0) as mmt0,
   avg(t1)/avg(d1) as mmt1,
    from oliSAS.BV2TC2H1;
    where cloneID like 'empty';

--
Oliver