(ABSOLUTE_COLUMN_WIDTH ='number-list '| 'NONE') specifies the columnwidths. Lists widths to use for columns instead of allowing SAS todetermine the column width (measured widths). The number-list isa comma separated list of numbers. You can use 'NONE' toreset to the default. Default None. SAS determines the width. Example ods excel file='footer.xlsx' options(absolute_column_width='16'); proc print data=sashelp.class(obs=5); run; ods excel close;
From the online help on ODS EXCEL. This sets the first column to 16. If you want to specify additional widths separate the values by columns in a list following absolute_column_width= such as ('1,12,45').
Columns to the right of the number specified are treated as default determined by SAS.
(ABSOLUTE_COLUMN_WIDTH ='number-list '| 'NONE') specifies the columnwidths. Lists widths to use for columns instead of allowing SAS todetermine the column width (measured widths). The number-list isa comma separated list of numbers. You can use 'NONE' toreset to the default. Default None. SAS determines the width. Example ods excel file='footer.xlsx' options(absolute_column_width='16'); proc print data=sashelp.class(obs=5); run; ods excel close;
From the online help on ODS EXCEL. This sets the first column to 16. If you want to specify additional widths separate the values by columns in a list following absolute_column_width= such as ('1,12,45').
Columns to the right of the number specified are treated as default determined by SAS.
As @ballardw showed you :
ods excel file='c:\temp\footer.xlsx' options(absolute_column_width='1,12,12,12,12,12,12' start_at="B1" embedded_titles='yes'); title justify=center bold height=12pt "REPORT TEST"; proc report data=sashelp.class(obs=5) nowd; run; ods excel close;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.