Date:         Sun, 18 Sep 2005 13:44:33 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Set restriction to output data
Comments: To: cychen9@GMAIL.COM

Just add a create (e.g., create table t2 as ) immediately following your
proc sql statement.

However, I do have to ask, are you getting your desired results or were
you more interested in selecting based on sum?  That is, are you really
trying to obtain something like:

proc sql;
  create table t2 as
    select class,
           sum(book) as cn
     from  t1
      group by class
       having cn = 1 ;
quit;

Art
---------
On Sun, 18 Sep 2005 09:47:02 -0700, tortoise <cychen9@GMAIL.COM> wrote:

>Thanks!
>After I add "having cn=1", the result showed in SAS output window.
> class  book
>   1       1
>   2       1
>   4       1
>
>How if I wanna to show in table t1 (in SAS Work Library) not in SAS
>output window?