ODS to create panel of tables

[Ronein]

Hello

I am using SAS enterprise guide 5.1

I want to create a panel of 5 tables (3 side by side tables  and 2 side by side tables)

 In the output I don't see side by side tables 

  ods tagsets.msoffice2k file="path\panels.xls"
 options(panelcols="3") style=normal;
 proc print data=sashelp.prdsale(obs=10);
 var actual predict country region;
 where country="CANADA";
 title "Canada Sales";
 run;
 proc print data=sashelp.prdsale(obs=10);
 var actual predict country region;
 where country="U.S.A.";
 title "USA Sales";
 run;
 proc print data=sashelp.prdsale(obs=10);
 var actual predict country region;
 where country="GERMANY";
 title "Germany Sales";
 run;
 ods tagsets.msoffice2k options(panelcols="2") ;
 proc print data=sashelp.prdsale(obs=20);
 where region="EAST";
 title "East Sales";
 run;
 proc print data=sashelp.prdsale(obs=20);
 where region="WEST";
 title "West Sales";
 run;
 ods tagsets.msoffice2k close;

[ChrisNZ]

1. Please format your code.

2. This example comes from page https://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html

3. This page states:

This section provides example code created with the sample Tagsets.MSOffice2K_x which modifies the MSOffice2K destination to add options to this new tagset. 

The sample code does not work with Tagsets.MSOffice2K as the option is not supported. Create and use Tagsets.MSOffice2K_x.

[Ronein]

I am using SAS enterprise guide 5.1

When I run TAGSETS.MSOFFICE2K_X I get a warning

"WARNING: Tagset TAGSETS.MSOFFICE2K_X not found; the default tagset will be used instead."

 

  ods tagsets.msoffice2k_x file="/path/panels.xls"
 options(panelcols="3") style=normal; 
proc print data=sashelp.prdsale(obs=10);
var actual predict country region;
where country="CANADA"; 
title "Canada Sales"; 
run;
proc print data=sashelp.prdsale(obs=10);
var actual predict country region;
where country="U.S.A.";
title "USA Sales"; 
run;
proc print data=sashelp.prdsale(obs=10);
var actual predict country region;
where country="GERMANY";
title "Germany Sales";
run; 
ods tagsets.msoffice2k_x options(panelcols="2") ; 
proc print data=sashelp.prdsale(obs=20); 
where region="EAST";
title "East Sales";
run;
proc print data=sashelp.prdsale(obs=20); 
where region="WEST"; 
title "West Sales";
run; 
ods tagsets.msoffice2k_x close;

[andreas_lds]

Follow the link supplied by @ChrisNZ, read the section titled "Introduction".

[ChrisNZ]

What's confusing about the page I pointed to, or about my sentence?

Create and use Tagsets.MSOffice2K_x.