BookmarkSubscribeRSS Feed
xxformat_com
Barite | Level 11

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%
3 REPLIES 3
SASKiwi
PROC Star

Why not just try it and see what happens?

xxformat_com
Barite | Level 11
I'Ve already tried it but I cannot see any difference.
xxformat_com
Barite | Level 11
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;

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1371 views
  • 2 likes
  • 2 in conversation