topic Re: ods excel SCREEN_RESOLUTION_SCALE_FACTOR= in ODS and Base Reporting

ods excel SCREEN_RESOLUTION_SCALE_FACTOR=

xxformat_com — Sat, 30 Oct 2021 11:10:26 GMT

Hi,

Has anyone an idea what the SCREEN_RESOLUTION_SCALE_FACTOR ods excel option for?

How can we observe a difference when using it?

SAS Online Doc

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p09n5pw9ol0897n1qe04zeur27rv.htm

(SCREEN_RESOLUTION_SCALE_FACTOR= 'display-scale-factor' | 'NONE')

specifies the scale factor to optimize viewing of Excel spreadsheets on high-resolution displays.

'display-scale-factor'

specifies the scale factor.

'NONE'

specifies that no scale factor is used.

DefaultTip

100%

Typical display scale factors are 125% or 150%

Re: ods excel SCREEN_RESOLUTION_SCALE_FACTOR=

SASKiwi — Sun, 31 Oct 2021 02:25:31 GMT

Why not just try it and see what happens?

Re: ods excel SCREEN_RESOLUTION_SCALE_FACTOR=

xxformat_com — Sun, 31 Oct 2021 13:34:26 GMT

I'Ve already tried it but I cannot see any difference.

Re: ods excel SCREEN_RESOLUTION_SCALE_FACTOR=

xxformat_com — Sun, 31 Oct 2021 13:35:38 GMT

ods excel file="&xxtest./reporting/ods_excel_test.xlsx"
options(screen_resolution_scale_factor='200%');

proc print data=sashelp.class;
run;

ods excel options(screen_resolution_scale_factor='50%');

proc print data=sashelp.class;
run;

ods excel close;