how to create custom table from results

393310 — Wed, 15 Dec 2021 22:56:36 GMT

Hi all,

Is there a way to pick out certain parts of your results and send to a new table? for example, in the solution for fixed effects below, I want just the estimate p- value and confidence interval in a new table but want to exclude the rest of the results :

what i want:

estimate	p value	lower	upper
-2.598	<.0001	-2.95	-2.2

I appreciate the help!

Re: how to create custom table from results

Reeza — Wed, 15 Dec 2021 23:00:27 GMT

Here's some instructions and explanations on how to capture output that is shown.
https://blogs.sas.com/content/sastraining/2017/03/31/capturing-output-from-any-procedure-with-an-ods-output-statement/

You don't specify the procedure so cannot help you with code but you can easily capture the table with an ODS statement and then filter out only the variables you want. It will likely look like the following:

ods output fixedEstimates = want (keep = estimtae pvalue lower upper);

@393310 wrote:

Hi all,

Is there a way to pick out certain parts of your results and send to a new table? for example, in the solution for fixed effects below, I want just the estimate p- value and confidence interval in a new table but want to exclude the rest of the results :

what i want:

estimate p value lower upper

-2.598 <.0001 -2.95 -2.2

I appreciate the help!

topic how to create custom table from results in SAS Programming

how to create custom table from results

Re: how to create custom table from results