proc summary output

[aloou]

hello every one,

i am running a proc summary on large number of table, now the output is like that

i need your help on how could i make the output table (second capture) as the first capture.

i would be so grateful.

the code is as follow :

proc summary data=x print n nmiss min max mean std;

output out=y;

VAR _NUMERIC_;

run;

thank you so much

[PaigeMiller]

proc summary data=x n nmiss min max mean std STACKODSOUTPUT;
    VAR _NUMERIC_;
    output out=y ;
run;

[aloou]

Mr Miller i am so grateful for all the help you provide.

i just tried what you wrote but still i am getting same tables as capture 2.

[PaigeMiller]

Show me the exact code you used, and the exact output it produces. Use the running man icon to provide the code. Show us the output via a screen capture, using the "Photos" button. No attachments, please.

[Tom]

Try using the ODS OUTPUT statement to get the table behind that report. 

You will need to know what its name is so use ODS TRACE to see what PROC SUMMARY names its ODS outputs.

[Reeza · Accepted solution]

ods select none;
proc means data=x print n nmiss min max mean std stackods;

VAR _NUMERIC_;
ods output summary = Y;
run;
ods select all;


proc print data=Y;
run;

I have examples of the different options here:

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas

You can run the code in your own SAS instance to see the output. 

---

@aloou wrote:

hello every one,

i am running a proc summary on large number of table, now the output is like that

i need your help on how could i make the output table (second capture) as the first capture.

i would be so grateful.

the code is as follow :

proc summary data=x print n nmiss min max mean std;

output out=y;

VAR _NUMERIC_;

run;

thank you so much

---

[aloou]

Thank you Mr Reeza , the code is working well.

i am so grateful for your help