| Date: | Tue, 10 Aug 2004 12:05:34 -0400 |
|---|
| Reply-To: | Michael Tuchman <mftuchman@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Michael Tuchman <mftuchman@YAHOO.COM> |
|---|
| Subject: | Re: Annoying cell in tabluate |
|---|
On Tue, 10 Aug 2004 08:42:16 -0700, Xavier Autret <xav_x@NOOS.FR> wrote:
The first thing to do in any proc tabulate question is to show us what
table you desire, including the layout of cells.
I am not sure what you mean by 'disposition of crosstabulation', so
perhaps it is best to show us an example. In this regard, perhaps it will
shed some light to know why you extract the same variable SALES twice in
your PROC SQL?
>proc sql;
> create view WORK.RETAIL as
> select * , SALES as SALES1 label='sales 1', SALES as SALES2
label='sales 2'
> from SASHELP.RETAIL
> where YEAR <= 1981
> ;
>quit;
>There's annoying cells at the right side of "sales 1" and "sales 2" :
>How can I remove them?
>
>Note : I want to keep the disposition of crosstabulation, so I do not
want write :
>table MONTH, YEAR*(SALES1*sum=''*f=numx. SALES2*sum=''*f=numx. );
>
><code>
>
>ods html file="%sysfunc(pathname(WORK, L))\see.html";
>proc tabulate data=WORK.RETAIL;
> class YEAR MONTH;
> var SALES1 SALES2;
> table YEAR*(SALES1*sum=''*f=numx. SALES2*sum=''*f=numx. ), MONTH;
>run;
>ods html close;
></code>
>
>Xavier Autret
| 
