Date: Fri, 27 Jan 2006 11:40:50 -0800
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: Formating in the proc means results
Content-Type: text/plain; format=flowed
ya.huang@AMYLIN.COM expertly replied:
>Howard has already suggested using proc tabulate. But his sample
>may not provide the lay out you want. I'm going to try again.
>If you don't mind separate date varaible with others:
>proc tabulate data=sashelp.class out=yy;
>var age weight height;
> (N*f=3. NMISS*f=3. (MIN MEAN MAX STD)*f=date9.);
> (N NMISS MIN MEAN MAX STD)*f=8.3;
I also agree that PROC TABULATE or PROC REPORT is the way to go with a table
However, I would make one *tiny* change in Ya's code.
proc tabulate data=sashelp.class out=yy;
var age weight height;
(N*f=3. NMISS*f=3. (MIN MEAN MAX)*f=date9. STD*f=6.3);
table weight height,
(N NMISS MIN MEAN MAX STD)*f=8.3;
It just doesn't make sense to report the standard deviation of dates as a
date-formatted value. It should be reported in number of days, which 6.3
The original poster's point about dealing with 20 variables is an issue.
he has to realize that he has some variables which cannot be given uniform
formats on the statistics, and so all of his variables have to be evaluated
a case-by-case basis.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Donít just search. Find. Check out the new MSN Search!