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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.