BookmarkSubscribeRSS Feed
leisas
Calcite | Level 5

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

Leigh

3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

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

cynthia

leisas
Calcite | Level 5

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

Cynthia_sas
SAS Super FREQ

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1439 views
  • 1 like
  • 2 in conversation