output summary report in SAS Studio

[mona4u]

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 

[Reeza]

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 

---

[mona4u]

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

[Reeza]

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

[mona4u]

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

[Reeza · Accepted solution]

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