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 */
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.