topic Re: how to output proc freq pvalue into a dataset in SAS Programming

how to output proc freq pvalue into a dataset

HitmonTran — Wed, 02 Nov 2022 16:24:34 GMT

hello, I'm trying to output a sas dataset for my one-sided p-values in proc freq step.

ods output CrossTabFreqs=want;

proc freq data=a; 
where treatn="virus";
table TFRELPRC_STD/binomial(p=0.234 level="Y") ; 
run;

Re: how to output proc freq pvalue into a dataset

ballardw — Wed, 02 Nov 2022 17:48:39 GMT

I think you are looking for

ods output binomialtest=want;

for the p values. There will be one row, matching the displayed table.

You can look up the table names in the documentation for Proc Freq under the Details tab with the ODS Table Names and see which tables are created by which Tables options. Or use ODS TRACE on; and ODS trace off; around the procedure you use to see which tables are generated by your code.

If you one one way freqs then request table ONEWAYFREQS, not Crosstabfreqs.

Re: how to output proc freq pvalue into a dataset

PaigeMiller — Wed, 02 Nov 2022 17:51:26 GMT

proc freq data=a; 
ods output binomialtest=binomialtest;
where treatn="virus";
table TFRELPRC_STD/binomial(p=0.234 level="Y") ; 
run;

Re: how to output proc freq pvalue into a dataset

Ksharp — Thu, 03 Nov 2022 11:47:34 GMT

proc freq data=a; 
where treatn="virus";
table TFRELPRC_STD/binomial(p=0.234 level="Y") ; 
output out=want binomial;
run;