Date:         Wed, 3 May 2000 13:17:20 GMT
Reply-To:     Renaud Harduin <r.harduin@ABS-TECHNOLOGIES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Renaud Harduin <r.harduin@ABS-TECHNOLOGIES.COM>
Organization: Guest of ProXad - France
Subject:      Re: How to use the output from Proc SQL

Do you try :
proc SQL;
create table MYLIB.MYTABLE as
select ... from ... where ...;
quit;

PS : Are You french (Olivier ?)


--
__________________________________
  Renaud Harduin  - tel. 06 03 82 96 39
                ABS-Technologies
     5, Rue du Helder - 75009 PARIS
        www.abs-technologies.com
__________________________________

oliver <oliver@agyinc.com> a écrit dans le message :
390F7EBA.5C970D41@agyinc.com...
> 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
>