Hi,
I'm trying to use ODS EXCEL to output my dataset.
Below is an example of my code.
data test; input ID$ age; cards; A 23 B 99 C 87 ; run; ods excel file="age.xlsx" options(sheet_name="test"); proc report data=test style(header)=[background=white font_face="Calibri" foreground=black] style(column)=[font_face="Calibri"] nowd; run; ods excel close;
The result is like the below picture, the background borders are not displayed.
I would like to keep all the borders like the one below, how can I modify my code?
Thanks in advance.
ods excel file="c:\temp\age.xlsx" options(sheet_name="test") style=minimal; proc report data=test style(header)=[ font_face="Calibri"] style(column)=[font_face="Calibri"] nowd; run; ods excel close;
Thanks for your help!
I have a small question. Is there any reference including all meanings of "style" in ODS EXCEL?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.