The ODS LAYOUT GRIDDED option ROW_SPAN might create incorrect or unexpected output in the ODS destination for PowerPoint. You might encounter two different incorrect behaviors.

• The first incorrect behavior occurs when one region is designated to span multiple rows. It might force another region within the same layout container to start on a new slide even though it should appear on the same slide as the first region.


• The second incorrect behavior occurs when the region does not span the specified rows. The output object is placed in only the first row.

Click the Full Code tab to see sample code that demonstrates both problems.

There is currently no circumvention for these issues.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	64-bit Enabled Solaris	9.4 TS1M0
		64-bit Enabled HP-UX	9.4 TS1M0
		64-bit Enabled AIX	9.4 TS1M0
		Windows 7 Professional x64	9.4 TS1M0
		Windows 7 Enterprise x64	9.4 TS1M0
		Microsoft Windows Server 2012 Std	9.4 TS1M0
		Microsoft Windows Server 2012 R2 Std	9.4 TS1M0
		Microsoft Windows Server 2012 R2 Datacenter	9.4 TS1M0
		Microsoft Windows Server 2012 Datacenter	9.4 TS1M0
		Microsoft Windows Server 2008 for x64	9.4 TS1M0
		Microsoft Windows Server 2008 R2	9.4 TS1M0
		Microsoft Windows 8.1 Pro 32-bit	9.4 TS1M0
		Microsoft Windows 8.1 Pro	9.4 TS1M0
		Microsoft Windows 8.1 Enterprise x64	9.4 TS1M0
		Microsoft Windows 8.1 Enterprise 32-bit	9.4 TS1M0
		Microsoft Windows 8 Pro x64	9.4 TS1M0
		Microsoft Windows 8 Enterprise x64	9.4 TS1M0
		Microsoft® Windows® for x64	9.4 TS1M0
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.4 TS1M0
		z/OS 64-bit	9.4 TS1M0
		z/OS	9.4 TS1M0
		HP-UX IPF	9.4 TS1M0
		Linux for x64	9.4 TS1M0
		Solaris for x64	9.4 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

The code below contains two separate programs. The first program demonstrates the problem in which ROW_SPAN incorrectly places output on a second slide. The second program demonstrates the problem in which ROW_SPAN is not being applied.

---

/* The PROC MEANS output is forced to a second slide.*/
ods powerpoint file="example1.ppt";

ods layout start columns=2 column_widths=(47pct 47pct);

   ods region row_span=2;
      ods text= "row_span=2";

   ods region;
      proc print data=sashelp.class(obs=10);
         var name age;
      run;

   ods region;
      ods noproctitle;
      proc means data=sashelp.class n mean;
      run;

ods layout end;

ods _all_ close;

/* The PROC REPORT output on the right is placed only on the first row. */
/* It is not spanning two rows as specified. */
ods powerpoint file="example2.pptx";

title;
footnote;
ods layout gridded
    width=24.0cm columns=3 column_widths=(8.8cm 8.8cm 5.4cm)
    rows=2 row_heights=(6.0cm  6.6cm) column_gutter=0.4cm row_gutter=1cm;

   ods region;
      proc report data=sashelp.class(obs=4) 
           style(report)={width=100pct}
           style(header)={fontsize=8pt background=cxadd8e6}
           style(column)={fontsize=8pt};
         column name ("Demographcis" sex age height weight);
      run;

   ods region;
      proc report data=sashelp.class(obs=4)
           style(report)={width=100pct}
           style(header)={fontsize=8pt background=cxadd8e6}
           style(column)={fontsize=8pt};
         column name ("Demographcis"  height weight);
      run;

 
   ods region row_span=2;
      proc report data=sashelp.class(obs=3) noheader
           style(report)={width=100pct};
         column name;
      run;

   ods region;
      ods graphics / width=8.7cm height=6.6cm;
      proc sgplot data=sashelp.class;
         vbar age;
      run;

   ods region;
      ods graphics / width=8.7cm height=6.6cm;
      proc sgplot data=sashelp.class;
         histogram age;
      run;

ods _all_ close;

The ROW_SPAN option might force part of the layout container to start on a new slide in the ODS destination for PowerPoint. In some situations, the output object might not span the specified rows.

Type:	Problem Note
Priority:	medium

Date Modified:	2015-10-14 15:41:27
Date Created:	2015-10-05 12:49:30