Help using Base SAS procedures

How to get PPT file with ods layout

Reply
Contributor
Posts: 74

How to get PPT file with ods layout

[ Edited ]

Hello,

 

I am coding to grab a PPT file in sas. But now encountering an issue. How to place the first three tables A, B, C as a group by stacking one after another and then place the last three D, E, F as a group by stacking one after another, and then separate the two groups, and then place the first group at the left side of the slide and the second group the right side of the slide. Please note, they need to be in one slide.  The code below is just as an example, which is incomplete. Thank you so much!

 


ods powerpoint file='/c/test.pptx' nogtitle nogfootnote;
title;
ods layout gridded columns=2 rows=3 advance=bygroup;
/*advance=bygroup;*/
ods region style={background=lightBlue just=right} width=61pct height=30pct x=4.5pct y=11.5pct;
/* ods text="^S={background=&backBlue. foreground=white font_size=20pt}ACME";*/
ods text="^S={background=lightBlue foreground=white font_size=10pt}Sales Report
Pacific Region";

 
Proc report data=A contents=" " nowd split='\' contents=" " nowd split='\'
style(header)={ just=center color=white background=cornflowerblue fontsize=2 font_weight=bold }
style(column)={ background=snow foreground=black fontsize=2 } ;  column ......: define.......; run;

Proc report data=B contents=" " nowd split='\' contents=" " nowd split='\'
style(header)={ just=center color=white background=cornflowerblue fontsize=2 font_weight=bold }
style(column)={ background=snow foreground=black fontsize=2 } ;  column ......: define.......; run;

Proc report data=C contents=" " nowd split='\' contents=" " nowd split='\'
style(header)={ just=center color=white background=cornflowerblue fontsize=2 font_weight=bold }
style(column)={ background=snow foreground=black fontsize=2 } ;  column ......: define.......; run;

ods region  style={background=lightBlue just=right} width=61pct height=30pct  x=54.5pct  y=11.5pct; 

Proc report data=contents=" " nowd split='\' contents=" " nowd split='\'
style(header)={ just=center color=white background=cornflowerblue fontsize=2 font_weight=bold }
style(column)={ background=snow foreground=black fontsize=2 } ;  column ......: define.......; run;

Proc report data=E contents=" " nowd split='\' contents=" " nowd split='\'
style(header)={ just=center color=white background=cornflowerblue fontsize=2 font_weight=bold }
style(column)={ background=snow foreground=black fontsize=2 } ;  column ......: define.......; run;

Proc report data=F contents=" " nowd split='\' contents=" " nowd split='\'
style(header)={ just=center color=white background=cornflowerblue fontsize=2 font_weight=bold }
style(column)={ background=snow foreground=black fontsize=2 } ;  column ......: define.......; run;

 


ods layout end;
ods powerpoint close;

 

Ask a Question
Discussion stats
  • 0 replies
  • 324 views
  • 0 likes
  • 1 in conversation