topic proc summary output in New SAS User

proc summary output

aloou — Mon, 14 Oct 2019 14:42:51 GMT

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

Re: proc summary output

PaigeMiller — Mon, 14 Oct 2019 15:53:26 GMT

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

Re: proc summary output

aloou — Mon, 14 Oct 2019 15:57:26 GMT

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.

Re: proc summary output

PaigeMiller — Mon, 14 Oct 2019 16:01:45 GMT

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.

Re: proc summary output

Tom — Mon, 14 Oct 2019 16:30:45 GMT

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.

Re: proc summary output

Reeza — Tue, 15 Oct 2019 00:04:54 GMT

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

Re: proc summary output

aloou — Tue, 15 Oct 2019 09:46:12 GMT

Thank you Mr Reeza , the code is working well.

i am so grateful for your help