How to save the outcome results from a proc freq?

[juliafervi]

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 · Accepted solution]

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]

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]

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

Thank you very much Paige Miller!