topic ODS to create panel of tables in SAS Programming

ODS to create panel of tables

Ronein — Thu, 08 Nov 2018 09:51:08 GMT

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;

Re: ODS to create panel of tables

ChrisNZ — Thu, 08 Nov 2018 22:21:39 GMT

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.

Re: ODS to create panel of tables

Ronein — Mon, 12 Nov 2018 08:17:24 GMT

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;

Re: ODS to create panel of tables

andreas_lds — Mon, 12 Nov 2018 09:47:06 GMT

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

Re: ODS to create panel of tables

ChrisNZ — Mon, 12 Nov 2018 22:04:33 GMT

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

Create and use Tagsets.MSOffice2K_x.