topic Re: output summary report in SAS Studio in SAS Studio

output summary report in SAS Studio

mona4u — Tue, 06 Mar 2018 17:49:30 GMT

I want to output my summary report to excel sheet. I tried the same codes I usually use for sas window but it diidn't work

Please let me know how I can do that

Re: output summary report in SAS Studio

Reeza — Tue, 06 Mar 2018 17:56:56 GMT

Can you post your code? What did you try that didn't work?

Usually you can just wrap your code in ODS EXCEL statements and get the results.

@mona4u wrote:

I want to output my summary report to excel sheet. I tried the same codes I usually use for sas window but it diidn't work

Please let me know how I can do that

Re: output summary report in SAS Studio

mona4u — Tue, 06 Mar 2018 17:59:34 GMT

I tried a code several weeks ago and I don't remember it right now

Re: output summary report in SAS Studio

Reeza — Tue, 06 Mar 2018 18:15:06 GMT

So you haven't tried it today...

There are some examples at the bottom of this page.

http://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en

Re: output summary report in SAS Studio

mona4u — Tue, 06 Mar 2018 18:24:57 GMT

now it's working but my tables are spread out in different worksheets

Re: output summary report in SAS Studio

Reeza — Tue, 06 Mar 2018 19:48:26 GMT

See the options in the link and find the one that controls the sheet output.