STACKODSOUTPUT (alias: STACKODS) is a new option on the PROC MEANS statement in SAS 9.3. When creating an output data set using the ODS OUTPUT statement, this option allows the data set to resemble the default printed output from PROC MEANS. In this structure, the analysis variables are stacked in one column and there is a column for each statistic. Without this option, the output data set contains a separate column for each analysis variable and statistic.

This option only affects output data sets created by the ODS OUTPUT statement, not the OUTPUT statement in PROC MEANS.

The code below demonstrates this option.

   proc means data=sashelp.class stackodsoutput sum mean std nway;
    class age;
    var height weight;
    ods output summary=with_stackods;
    title 'Default printed output from PROC MEANS';
   run;

   proc print data=with_stackods noobs;
    title 'Output data set with STACKODSOUTPUT';
   run;

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	Base SAS	z/OS	9.3_M1
		Z64	9.3_M1
		Microsoft® Windows® for x64	9.3_M1
		Microsoft Windows 95/98	9.3_M1
		Microsoft Windows 2000 Advanced Server	9.3_M1
		Microsoft Windows 2000 Datacenter Server	9.3_M1
		Microsoft Windows 2000 Server	9.3_M1
		Microsoft Windows 2000 Professional	9.3_M1
		Microsoft Windows NT Workstation	9.3_M1
		Microsoft Windows Server 2003 Datacenter Edition	9.3_M1
		Microsoft Windows Server 2003 Enterprise Edition	9.3_M1
		Microsoft Windows Server 2003 Standard Edition	9.3_M1
		Microsoft Windows Server 2003 for x64	9.3_M1
		Microsoft Windows Server 2008	9.3_M1
		Microsoft Windows Server 2008 for x64	9.3_M1
		Microsoft Windows XP Professional	9.3_M1
		Windows 7 Enterprise 32 bit	9.3_M1
		Windows 7 Enterprise x64	9.3_M1
		Windows 7 Home Premium 32 bit	9.3_M1
		Windows 7 Home Premium x64	9.3_M1
		Windows 7 Professional 32 bit	9.3_M1
		Windows 7 Professional x64	9.3_M1
		Windows 7 Ultimate 32 bit	9.3_M1
		Windows 7 Ultimate x64	9.3_M1
		Windows Millennium Edition (Me)	9.3_M1
		Windows Vista	9.3_M1
		Windows Vista for x64	9.3_M1
		64-bit Enabled AIX	9.3_M1
		64-bit Enabled HP-UX	9.3_M1
		64-bit Enabled Solaris	9.3_M1
		HP-UX IPF	9.3_M1
		Linux	9.3_M1
		Linux for x64	9.3_M1
		Solaris for x64	9.3_M1

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Default printed output from PROC MEANS

The MEANS Procedure

                  N
         Age    Obs    Variable             Sum            Mean         Std Dev
          11      2    Height        108.800000       54.400000        4.384062
                       Weight        135.500000       67.750000       24.395184

          12      5    Height        297.200000       59.440000        3.297423
                       Weight        472.000000       94.400000       20.528639

          13      3    Height        184.300000       61.433333        4.495924
                       Weight        266.000000       88.666667        8.082904

          14      4    Height        259.600000       64.900000        2.801190
                       Weight        407.500000      101.875000        9.213893

          15      4    Height        262.500000       65.625000        2.096624
                       Weight        469.500000      117.375000       10.419333

          16      1    Height         72.000000       72.000000               .
                       Weight        150.000000      150.000000               .

Output data set with STACKODSOUTPUT

         Age NObs _control_ Variable          Sum         Mean       StdDev

          11   2             Height    108.800000    54.400000     4.384062
          11   2             Weight    135.500000    67.750000    24.395184
          12   5      1      Height    297.200000    59.440000     3.297423
          12   5             Weight    472.000000    94.400000    20.528639
          13   3      1      Height    184.300000    61.433333     4.495924
          13   3             Weight    266.000000    88.666667     8.082904
          14   4      1      Height    259.600000    64.900000     2.801190
          14   4             Weight    407.500000   101.875000     9.213893
          15   4      1      Height    262.500000    65.625000     2.096624
          15   4             Weight    469.500000   117.375000    10.419333
          16   1      1      Height     72.000000    72.000000            .
          16   1             Weight    150.000000   150.000000            .

The STACKODSOUTPUT option allows the ODS output object to resemble the default printed output.

Type:	Usage Note
Priority:
Topic:	SAS Reference ==> ODS (Output Delivery System)

Date Modified:	2012-04-27 14:38:39
Date Created:	2012-04-26 13:20:46