Date:         Fri, 14 Dec 2007 16:12:12 -0500
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Proc tabulate won't accept var list shortcut (was Re: on listing
              variables in a file in a concise way)

I noticed this for a while, just curious, why
I can't use a shortcut for table statment:

table v1-v10, (n mean std min max);

Other proc that won't allow shortcut is SQL, that I can
understand, but tabulate?


>data xx;
>array vv(10) v1-v10;
>do j=1 to 100;
>  do i=1 to 10;
>  vv(i)=ranuni(0);
>  end;
>output;
>end;
>run;
>
>proc tabulate data=xx noseps;
>var v1-v10;
>table v1 v2 v3 v4 v5 v6 v7 v8 v9 v10, (n mean std min max)
*f=best6. /rts=10;
>run;
>
>---------------------------------------------
>|        |  N   | Mean | Std  | Min  | Max  |
>|--------+------+------+------+------+------|
>|v1      |   100|0.4933|0.3068| 0.012|0.9845|
>|v2      |   100|0.5264|0.3089|0.0328|0.9868|
>|v3      |   100|0.4908|0.2877|0.0001|0.9965|
>|v4      |   100|0.5072|0.2591|0.0415|0.9647|
>|v5      |   100|0.5953|0.2447|0.0327|0.9758|
>|v6      |   100|0.4968|0.2796|0.0147|0.9843|
>|v7      |   100|0.5009|0.3056|0.0171|0.9993|
>|v8      |   100|0.5033|0.3028|0.0098|0.9939|
>|v9      |   100|0.4961|0.2708|0.0032| 0.988|
>|v10     |   100|0.4088|0.2999|0.0131|0.9969|
>---------------------------------------------
>