topic Re: ODS OUTPUT WilcoxonTest for PROC NPAR1WAY gives ambiguous result in Statistical Procedures

ODS OUTPUT WilcoxonTest for PROC NPAR1WAY gives ambiguous result

Kirill_Voronov — Wed, 08 Sep 2021 22:31:25 GMT

Hello SAS community!

While reading this paper (page 12), I came across an ambiguous output.

Judging by the code given in the paper (screenshot attached),

the output dataset wtestp should contain the following variables:

Name1
cValue1
nValue1

However, when trying to reproduce the output (at least in sas version 9.4), it turned out to be completely different (not in relation to the data presented, but in relation to the structure of the data set).

A reproducible example:

ods output WilcoxonTest = wtestp;
proc npar1way data = sashelp.class wilcoxon;
	class sex;
	var age;
run;

The wtestp output is not at all similar to that in paper. It doesn't contain any variables with such names, and none of the variables contains the values "P2_WALL" 2_WALL.

It is clear that the p-values are eventually obtained. But, this output doesn't allow them to be used in the macro as it was originally intended.

Is it possible that I am doing something wrong and there is an opportunity to get the desired result?

Thank in advance for any help!

Re: ODS OUTPUT WilcoxonTest for PROC NPAR1WAY gives ambiguous result

ballardw — Thu, 09 Sep 2021 01:11:52 GMT

Do not expect the same sorts of output when you remove BY variables from code.

This, which uses a BY statement does have those variables.

proc sort data=sashelp.class
    out=work.class;
    by age;
run;
ods output WilcoxonTest = wtestp;
proc npar1way data = work.class wilcoxon;
   by age;
   class sex;
   var height;
run;

If you want to use code from someone else's macros your call and data have to match, in this case include a BY statement. Even a trivial variable:

data work.classjunk;
   set sashelp.class;
   bybob='1';
run;
ods output WilcoxonTest = wtestp;
proc npar1way data = work.classjunk wilcoxon;
   by bybob;
	class sex;
	var height;
run;

The target of that paper is to use BY group processing as way to avoid making multiple single procedure calls to get the output for multiple calls. So when you bypass the multiple calls, i.e. BY group processing, then the data is not in the expected form to use the reporting parts because it would not be needed.

Re: ODS OUTPUT WilcoxonTest for PROC NPAR1WAY gives ambiguous result

Kirill_Voronov — Thu, 09 Sep 2021 08:43:41 GMT

ballardw

Thank you for replying, but I have already tested the option with BY statement.

Adding this setting does not affect the response dataset format.

For example, your first example gives the following result:

There are no variables named Name1, cValue1, nValue1... which i need to my own macro.

At the same time, the ODS output from PROC FREQ gives exactly what I want (but I want this for the PROC NPAR1WAY):

ods output FishersExact = ftestp;
proc freq data = sashelp.cars;
	tables  origin*drivetrain/exact;
run;

Thank you!

Re: ODS OUTPUT WilcoxonTest for PROC NPAR1WAY gives ambiguous result

Rick_SAS — Thu, 09 Sep 2021 10:06:33 GMT

According to the documentation, PROC NPAR1WAY changed the format of score test tables in SAS/STAT 15.1 (SAS 9.4M6). The doc says "You can specify the TABLES=RESTORE option in the PROC NPAR1WAY statement to display these tables in factoid (label-value) format, which is their format in releases before SAS/STAT 15.1."

For your reproducible example:

ods output WilcoxonTest = wtestp;
proc npar1way data = sashelp.class wilcoxon tables=restore;
	class sex;
	var age;
run;

proc print data=wtestp; run;

Re: ODS OUTPUT WilcoxonTest for PROC NPAR1WAY gives ambiguous result

Kirill_Voronov — Thu, 09 Sep 2021 10:26:53 GMT

Thank you very much. It helped a lot!