how to create custom table from results

[393310]

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!

[Reeza · Accepted solution]

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...

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!

---