Hello, I am trying to create a PowerPoint presentation with a custom layout for one of the slides (2 rows, 2 columns). For the custom layout I have been trying to use ODS Layout Gridded, but have not been able to get it to show up on the slide correctly. It seems that SAS is trying to add the content of the Gridded layout slide to the previous slide. Any suggestions? Below is a simplified version of the code I am working with, and it has the same effect. I am using SAS EG 6.1. Thanks, Craig proc sql;
create table cars as
select Make,
sum(MSRP) as TotMSRP format=dollar10.
from sashelp.cars
group by Make;
quit;
ods powerpoint file="cars.pptx" layout=_null_;
/*Slide 1 with text in bottom left corner.*/
proc odstext;
p "";
p "";
p "";
p "";
p "";
p "";
p "";
p "";
p "Daily Report" / style={fontweight=bold fontsize=36pt};
p "%sYsFunc(putn(%sYsFunc(today()),WeekDate.))" / style={fontweight=bold fontsize=20pt};
run;
/*Slide 2 with a gridded layout*/
ods layout gridded rows=2 columns=2;
ods graphics / width=8in height=3in;
ods region row=1 column_span=2;
proc sgplot data = cars;
vbar Make / response=TotMSRP
nostatlabel name="bar" nooutline;
yaxis min=0 offsetmin=0 values=(0 to 1650000 by 150000) grid
label="Total MSRP";
xaxis display=(noticks nolabel);
run;
ods region row=2 column=1;
proc odslist;
item;
p "Car Makes" / style={fontweight=bold fontsize=10pt};
list;
item "Acura" / style={fontsize=10pt};
item "Audi" / style={fontsize=10pt};
item "BMW" / style={fontsize=10pt};
item "Buick" / style={fontsize=10pt};
item "ETC" / style={fontsize=10pt};
end;
end;
run;
ods region row=2 column=2;
proc odslist;
item;
p "Car Makes" / style={fontweight=bold fontsize=10pt};
list;
item "Acura" / style={fontsize=10pt};
item "Audi" / style={fontsize=10pt};
item "BMW" / style={fontsize=10pt};
item "Buick" / style={fontsize=10pt};
item "ETC" / style={fontsize=10pt};
end;
end;
run;
ods layout end;
ods powerpoint close;
... View more