DATA Step, Macro, Functions and more

Different N obs between proc means and proc npar1way

Accepted Solution Solved
Reply
Regular Contributor
Posts: 154
Accepted Solution

Different N obs between proc means and proc npar1way

I am running a 2 sample wilcoxon and also supplementing my p-value with with medians using proc means. However, the number of obs in each are different: proc means reports I have 3 in my class variable whereas npar1way reports I have 2. What can be the reason for this?

 

proc means data=x median;
    where group = "A";
    class sub;
    var change;
run;

proc npar1way data=x wilcoxon;
    where group = "A";
    class sub;
    var change;
    exact;
run;


Accepted Solutions
Solution
‎01-26-2018 02:00 PM
Occasional Contributor svh
Occasional Contributor
Posts: 16

Re: Different N obs between proc means and proc npar1way

You can add 'nmiss' to your PROC MEANS statement to try to examine missingness of the continuous variables at the class level. 

 

Or, have you tried running a PROC FREQ to examine the categorical variables and their frequencies. That might help.

 

Such as 

 

PROC FREQ DATA=X;

  TABLES SUB;

  TABLES GROUP;

  TABLES SUB*GROUP;

RUN;

View solution in original post


All Replies
Solution
‎01-26-2018 02:00 PM
Occasional Contributor svh
Occasional Contributor
Posts: 16

Re: Different N obs between proc means and proc npar1way

You can add 'nmiss' to your PROC MEANS statement to try to examine missingness of the continuous variables at the class level. 

 

Or, have you tried running a PROC FREQ to examine the categorical variables and their frequencies. That might help.

 

Such as 

 

PROC FREQ DATA=X;

  TABLES SUB;

  TABLES GROUP;

  TABLES SUB*GROUP;

RUN;

SAS Super FREQ
Posts: 4,172

Re: Different N obs between proc means and proc npar1way

In PROC MEANS, "NObs" is the total number of observations in each group. It includes missing and nonmissing. To see the number of observations that are used in the analysis, put N and NMISS on the PROC MEANS statement:

 

proc means data=x N NMISS median ;
    where group = "A";
    class sub;
    var change;
run;

The "N" column should match the "N" column in NPAR1WAy.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 146 views
  • 1 like
  • 3 in conversation