BookmarkSubscribeRSS Feed
working_bot
Calcite | Level 5

First time post here. Please let me know how to make it better.

 

I try formatting a bullet list in a text box and a table on ods powerpoint.

 

My desired format (see below screenshots):

  • The whole text box background color should be yellow. The first line "Comment Box" should not have a bullet.
  • The text box and table below should start at the most left of the slide, leaving no margin.
  • The table's Cell Margins should be all 0s. (In PowerPoint it is in Layout - Cell Margins)

Below is my code:

  *HTML output;
  ods html;

  *PPT output;
  options nocenter orientation=landscape topmargin=0in bottommargin=0in 
        leftmargin=0in rightmargin=0in papersize=(13.33in 7.5in);
  ods powerpoint file=".\__temp.pptx" nogtitle nogfootnote;

  *Title and comment box;
  ods layout gridded x=0pct y=0pct;
  ods region;
  proc odstext; p "Title" / style=[color=green TEXTALIGN=L FONTWEIGHT=BOLD FONTSIZE=24pt]; run;
  proc odslist;
/*  cellstyle 1 as {background=lightyellow};*/
  item / style={liststyletype="none" TEXTALIGN=L fontsize=12pt background=yellow};
    p "Comment Box";
    p "Comment Box2";
    list / style={liststyletype="disc" TEXTALIGN=L fontsize=12pt FONTWEIGHT=BOLD background=yellow};
     item "Bullet1";
     item "Bullet2";
    end;
  end;
  run;
  ods layout end;

  *A table;
  ods layout gridded;
  ods region;
  proc print data=sashelp.class  noobs label WIDTH=MINIMUM
  style(header)={cellpadding=0pt /*paddingleft=0pt paddingright=0pt*/ paddingbottom=0pt paddingtop=0pt foreground=black background=grey fontsize=11pt just=c}
  style(column)={cellpadding=0pt paddingleft=0pt paddingright=0pt paddingbottom=0pt paddingtop=0pt fontsize=11pt just=c}
  ;
  run;  
  ods layout end;

  *Close and Output;
  ods powerpoint close;

Below is the original PowerPoint output screenshot.

 

working_bot_0-1717598471930.png

Below is what I would like to have.

working_bot_1-1717598530803.png

 

Thank you in advance!

 

1 REPLY 1
Ksharp
Super User

You could use PROC REPORT to replace PROC ODSLIST.

options nocenter orientation=landscape topmargin=0in bottommargin=0in 
        leftmargin=0in rightmargin=0in papersize=(13.33in 7.5in);
  ods powerpoint file="c:\temp\temp.pptx" nogtitle nogfootnote;
title;

data x;
input x $80.;
cards;
Comment Box
Comment Box2
(*ESC*){style [foreground=yellow].......}●    Bullet1
(*ESC*){style [foreground=yellow].......}●    Bullet2
;

  *Title and comment box;
  ods layout gridded x=0pct y=0pct;
  ods region;
  proc odstext; p "Title" / style=[color=green TEXTALIGN=L FONTWEIGHT=BOLD FONTSIZE=24pt]; run;


proc report data=x nowd noheader 
style(column)={rules=none frame=void background=yellow bordercolor=yellow fontsize=12pt cellpadding=0 cellspacing=0};
run;


  ods layout end;

  *A table;
  ods layout gridded;
  ods region;
  proc print data=sashelp.class(obs=10)  noobs label WIDTH=MINIMUM
  style(header)={cellpadding=0pt /*paddingleft=0pt paddingright=0pt*/ paddingbottom=0pt paddingtop=0pt foreground=black background=grey fontsize=11pt just=c}
  style(column)={cellpadding=0pt paddingleft=0pt paddingright=0pt paddingbottom=0pt paddingtop=0pt fontsize=11pt just=c}
  ;
  run;  
  ods layout end;

  *Close and Output;
  ods powerpoint close;

Ksharp_0-1717643853807.png

 

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 257 views
  • 0 likes
  • 2 in conversation