Hi,
i use this code to genearate an excel report:
ODS excel file= "&bedr.\&rapp..xlsx" style=excel
options(sheet_name="&rapp." flow="tables" ABSOLUTE_COLUMN_WIDTH ='175px,210px,126px,348px,210px,203px,91px,91px,119px,147px,126px,133px,91px,91px,91px'
absolute_row_height='20px');
proc print data=mydataset noobs LABEL;
run;
ODS excel CLOSE;
I run the code in SAS EG, it works fine. In an other sas session several options are not working, column width in pixels, style = excel and flow = "tables"
How would that be possible?
What system options could make the difference?
Regards,
Dirk
Hi Cyntia,
Thanks for your answer.
i am using the same code in the two different SAS sessions.
One is 'development', the other is 'production'.
I'm trying to find out what should be done to make sure the output is the same. One would of course assume that both environments are the same, which apparently is not.
Regards,
Dirk
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 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.