topic Obtain Pvalue in SAS Procedures

Obtain Pvalue

RAVI2000 — Tue, 19 Apr 2022 01:29:09 GMT

Hello everyone,

I was trying to obtain pvalue using proc freq. But, looks like there are no cross tabulations. Is there any other alternative to obtain the p-values for these variable?

proc freq data = test2;
2082       	tables non_femaleacademicprod * male_parent_aca_pro/ chisq;
2083       	ods output ChiSq = chsq9(where=(Statistic = "Mantel-Haenszel
2083     ! Chi-Square"));
2084       run;

WARNING: Output 'ChiSq' was not created.  Make sure that the output object 
         name, label, or path is spelled correctly.  Also, verify that the 
         appropriate procedure options are used to produce the requested output 
         object.  For example, verify that the NOPRINT option is not used.

Thanks!

Re: Obtain Pvalue

RAVI2000 — Tue, 19 Apr 2022 02:10:25 GMT

Those both variable used in tables statement are ordinal.

1- Large -ve impact
2- Small -ve impact
3- No impact
4- Large + impact
5- Small +ve impact

Re: Obtain Pvalue

Rick_SAS — Tue, 19 Apr 2022 10:47:17 GMT

Here is some code that works. I used a WEIGHT variable so that I would not need to type some many rows of data. I also used 4 categories instead of 5.

data Test2;
input non_femaleacademicprod male_parent_aca_pro Count;
datalines;
1 1 27
1 2 13
1 3 23
1 4 33
2 1 37
2 2 23
2 3 13
2 4 15
3 1 14
3 2  9
3 3  5
3 4  7
4 1 14
4 2  9
4 3  5
4 4 12
;

ods trace on;
proc freq data = test2;
weight Count;
tables non_femaleacademicprod * male_parent_aca_pro/ chisq;
ods output ChiSq = chsq9(where=(Statistic="Mantel-Haenszel Chi-Square"));
run;

proc print data=Chsq9;
run;

Since my code works and yours does not, I suspect you might have a typo in the WHERE clause. First, output the entire data set of statistics by using

ods output ChiSq = chsq9;

Do you see the data? If so, it is your WHERE clause that is incorrect. Make sure there are no extra spaces. If necessary, use a simpler WHERE clause such as

ods output ChiSq = chsq9(where=(Statistic contains "Mantel"));

Re: Obtain Pvalue

ballardw — Tue, 19 Apr 2022 14:54:49 GMT

Did you include the ENTIRE log for that Proc Freq?

I know that I can create the same warning with a data set that only has one level of a variable on the Tables statement but that shows a note about that as well.

Re: Obtain Pvalue

RAVI2000 — Thu, 21 Apr 2022 20:41:17 GMT

My data was not cleaned properly thus giving the error.