topic Proc means - nway and missing option in SAS Programming

Proc means - nway and missing option

David_Billa — Mon, 20 Jun 2022 04:54:25 GMT

Appreciate if any one of you help me understand the purpose of nway and missing option in proc means. My understanding is, it will delete the records if the values of class variable is missing.

proc means data=stack nway noprint missing;
class SNAP_DATE loc loc_name bu ip_code matrl_typ  storage_loc material ;
output out=MB_SUMMARY(drop=_:) sum(UNRSTR_QTY_DOL UNRSTR_QTY_UL)=;
run;

Re: Proc means - nway and missing option

Kurt_Bremser — Mon, 20 Jun 2022 06:33:16 GMT

As always, Maxim 1: Read the Documentation.

From the documentation of the PROC MEANS Statement:

NWAY

specifies that the output data set contain only statistics for the observations with the highest _TYPE_ and _WAY_ values. When you specify class variables, NWAY corresponds to the combination of all class variables.

Interaction	If you specify a TYPES statement or a WAYS statement, then PROC MEANS ignores this option.
See	Output Data Set
See	Computing Output Statistics with Missing Class Variable Values

which means that statistics for higher-up CLASS variables (in your example, (e.g.) the discrete values of SNAP_DATE) are not calculated, only those for the combination of all CLASS variables.

MISSING

considers missing values as valid values to create the combinations of class variables. Special missing values that represent numeric values (the letters A through Z and the underscore (_) character) are each considered as a separate value.

Default	If you omit MISSING, then PROC MEANS excludes the observations with a missing class variable value from the analysis.
See	SAS Language Reference: Concepts for a discussion of missing values that have special meaning.
See	Using Preloaded Formats with Class Variables

self-explanatory

Re: Proc means - nway and missing option

David_Billa — Mon, 20 Jun 2022 06:40:25 GMT

@Kurt_Bremser Well, any thoughts to how to explain this code to R programmers in simple language?

Re: Proc means - nway and missing option

Kurt_Bremser — Mon, 20 Jun 2022 06:57:33 GMT

Create the statistics with one line or each combination of all CLASS variables; consider missing values in a CLASS variable as valid.

Re: Proc means - nway and missing option

PaigeMiller — Mon, 20 Jun 2022 10:38:36 GMT

You can try running PROC MEANS without these options (one at a time) and see the difference in the output. If that and the documentation still doesn't make sense, ask specific questions.