Date:         Wed, 7 Mar 2012 20:56:01 -0500
Reply-To:     Nat Wooding <nathani@VERIZON.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <nathani@VERIZON.NET>
Subject:      Re: Proc Means to Excel File as Sheet
Comments: To: Thomas George <tgeorgeturutiyil@GMAIL.COM>
In-Reply-To:  <201203071611.q275SXKC017580@wasabi.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

If you don't want the sheet to be dressed up, you can specify the fully name
of the workbook in a Libname statement. Then, add the libname to output
specification.

Libname outfile 'C:\whatever\my workbook.xls';
 proc means data=OSCE_Neph nway nmiss mean std skew Median; class Station
SP_MD; var Q1resp Q2Resp Q3Resp Q4Resp Q5Resp Q6Resp;
 output out =
Outfile.StationsData
mean= std= skew= Median=; run;


You may need to write this as
Outfile.'StationsData$'n

Nat Wooding
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Thomas
George
Sent: Wednesday, March 07, 2012 11:11 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Means to Excel File as Sheet

proc means data=OSCE_Neph nway nmiss mean std skew Median; class Station
SP_MD; var Q1resp Q2Resp Q3Resp Q4Resp Q5Resp Q6Resp; output out =
StationsData mean= std= skew= Median=; run;


How can i get the Mean Std Skew Median of the responses in the final data
set?
Also in stationsdata i get _type_ as 3 in the rows. Why is that?

Thanks,

Thomas