Proc means output options vs stocks

Note:    If THREADS is specified (either as a SAS system option or on the PROC MEANS statement) and another program has the input data set open for reading, writing, or updating, then PROC MEANS might fail to open the input data set. In this case, PROC MEANS stops processing and writes a message to the SAS log.   

Advanced Subqueries In PROC SQL - Systems...

excludes observations with nonpositive weight values (zero or negative) from the analysis. By default, PROC MEANS treats observations with negative weights like observations with zero weights and counts them in the total number of observations.

PHP: proc_open - Manual

By default the statistics in the output data set automatically inherit the analysis variable's format, informat, and label. However, statistics computed for N, NMISS, SUMWGT, USS, CSS, VAR, CV, T, PROBT, PRT, SKEWNESS, and KURTOSIS will not inherit the analysis variable's format because this format might be invalid for these statistics (for example, dollar or datetime formats).

Prashant, thanks for the comment. I think you've been following the tech advancements in SAS around dealing with Excel files, and you can see things have improved quite a bit in the past couple of releases. Aside from ODS EXCEL (for writing files), we now have XLSX export/import support on Unix without the need for a separate PC Files Server node -- but it still requires that SAS/ACCESS to PC Files license. I can't say what the future holds that will change anytime soon. But I'd suggest that it's a good conversation to have with your SAS site rep about the business needs and making sure that you have the correct mix of SAS products to support the work you're doing.

includes a variable named _LEVEL_ in the output data set. This variable contains a value from 6 to n that indicates a unique combination of the values of class variables (the values of _TYPE_ variable).

To add to an existing workbook, you'll have to use PROC EXPORT to add/replace a sheet. You can use TABULATE to create the output data set (see this note) , then PROC EXPORT to send it to Excel.

names the new output data set. If SAS-data-set does not exist, then PROC MEANS creates it. If you omit OUT=, then the data set is named DATA n , where n is the smallest integer that makes the name unique.

specifies that one or more identification variables be associated with the maximum values of the analysis variables. The form of the maximum-id-specification is

identifies the numeric analysis variable whose maximum values PROC MEANS determines. PROC MEANS can determine several maximum values for a variable because, in addition to the overall maximum value, subgroup levels, which are defined by combinations of class variables values, also have maximum values.

If you have not tried, have a look at the options statement in SAS SAS Options Statement. There is a PageSize option which can be set.

Add a comment

Your e-mail will not be published. Required fields are marked *