Sorry, I just posted my question, and attached wrong file. I attached here again.
Leigh
Hi:
I already added some general comments to your previous post that might prove helpful.
cynthia
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: