topic Re: How to save the outcome results from a proc freq? in New SAS User

How to save the outcome results from a proc freq?

juliafervi — Fri, 26 Oct 2018 15:27:12 GMT

Dear all I have the following question:

How do I save or have direct (calling) acces to the some desired variables obtained using "proc freq / binomial test".

I have been able to obtain the results in a separeted excel sheet... but that is not what I am looking for.

I would like to be able to call the varibales such as the "p" and the "confidence interval" results for then creating an END RESULT TABLE.

Thanks in advance,

Julia

PaigeMiller — Fri, 26 Oct 2018 15:44:31 GMT

ods output onewayfreqs=freqs binomial=binomial binomialtest=binomialtest;
proc freq data = have;
    tables variablename/binomial;
run;

In general, any SAS procedure output can be captured and placed into a SAS data set by using the proper ODS OUTPUT statement.

juliafervi — Mon, 29 Oct 2018 13:08:26 GMT

Hi yes this seems to work. However the main point of the confidence limit are not in the output tables.

I would like to obtain this information :

Confidence Limits for the Binomial ProportionProportion = 0.0933
Type95% Confidence Limits
Clopper-Pearson (Exact) 0.0520 0.1516

What would be the correct statement to call the confidence interval in the "ods output" ?

Thanks for the tip!!

juliafervi — Mon, 29 Oct 2018 13:42:07 GMT

found "BinomialCLs" perfect for what I was looking for.

Thank you very much Paige Miller!