Hi All,
I would like to set the size of my graphs in ODS Excel.
The current out put sizes the graphs to 9.87cm x 14.99cm (3.88inch x 5.9inch)
I would like to set the graphs to 17cm x 26cm (6.6inch x 10.2inch)
I have used both of the below to no avail.
ods graphics on / width=8in height=4in;
goptions vsize=10cm hsize=20cm
%let DateVAR = %sysfunc(intnx(day,%sysfunc(today()),-1),yymmddn8.);
ods excel file="/test/Testa&DateVAR..XLSX";
ODS EXCEL OPTIONS (EMBEDDED_Titles="YES" sheet_Interval="NONE");
ODS Excel Options (embedded_Titles="YES") NOGTITLE NOGFOOTNOTE;
ods graphics on / width=8in height=4in;
ods excel options(sheet_name='Overall');
Proc SGPLOT data=test;
Series x=Date y=successful / lineattrs=(color=blue thickness=3) Legendlabel='Successful';
Series x=Date y=Unsuccessful / lineattrs=(color=RED thickness=3) Legendlabel='UnSuccessful';
yaxis display=(noline noticks) grid values=(0 to 325000 by 25000) offsetmin=0 label='Count';
Format Successful UnSuccessful comma9.;
RUN;
Any help in resizing the graphs is appreciated.
Cheers
Dean
I ran into this issue today. It looks like SAS writes pages to excel to fit the default destination print size. I changed the output orientation and papersize to a format that better fit my needs as follows:
options orientation=LANDSCAPE; /* LANDSCAPE/PORTRAIT */
options papersize=legal; /* LETTER is 11 X 8.5, LEGAL is 14 X 8.5 */
I ran into this issue today. It looks like SAS writes pages to excel to fit the default destination print size. I changed the output orientation and papersize to a format that better fit my needs as follows:
options orientation=LANDSCAPE; /* LANDSCAPE/PORTRAIT */
options papersize=legal; /* LETTER is 11 X 8.5, LEGAL is 14 X 8.5 */
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.