The SAS Output Delivery System and reporting techniques

ODS EXCEL OUTPUT FORMAT

Reply
Contributor
Posts: 24

ODS EXCEL OUTPUT FORMAT

Sorry, I just posted my question, and attached wrong file.  I attached here again.

Leigh

Attachment
SAS Super FREQ
Posts: 8,866

Re: ODS EXCEL OUTPUT FORMAT

Hi:

  I already added some general comments to your previous post that might prove helpful.

cynthia

Contributor
Posts: 24

Re: ODS EXCEL OUTPUT FORMAT

Posted in reply to Cynthia_sas

Cynthia,

Thank you for the quick responce.

I want to thank you for my previous question (HTML). I took your suggestion and it worked!

You're right. before I received your answer for ODS tagsets, it suddenly occured to me that I could try the suggestion you gave to me for ODS HTML. It worked out fine for font_size, but still it won't get centered (style(data) ={just=c } and the column was too wide. I guss I can narrow the column by style= . ?

Another problem, how can I show title to every sheet?

Thank you so mcu!

Leigh

SAS Super FREQ
Posts: 8,866

Re: ODS EXCEL OUTPUT FORMAT

Hi:

  Did you look at the screenshot that I attached to my other post?

https://communities.sas.com/message/139542#139542

  I used TAGSETS.EXCELXP in that posting example. And you can see that my justification worked in those outputs. So somehow I believe the interaction of absolute_column_width that you have and width_fudge are probably preventing the justification from being what you want. If you run my very simplified code, do you see justification changes? If so, then you need to add suboptions very carefully.

  Also, in my response to your other posting, I put (at the top), a Tech Support note that explained the TITLE behavior. I believe the fix is to use PAGEBY, but my suggestion is that you read the Tech Support note that I posted and these other notes, too:

http://support.sas.com/kb/43/559.html

http://support.sas.com/kb/46/621.html

http://support.sas.com/kb/45/204.html

http://support.sas.com/kb/38/198.html

If you continue to have problems with TAGSETS.EXCELXP and you can't get it working, your sub-options may be at fault -- they could be specifying incompatible settings. I generally recommend starting over with no sub-options (such as I showed in my screen shot) and then add sub-options until they either work or a sub-option "breaks" -- then you have 1 specific thing to ask of Tech Support.

cynthia

Ask a Question
Discussion stats
  • 3 replies
  • 377 views
  • 1 like
  • 2 in conversation