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;
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.
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;
Follow the link supplied by @ChrisNZ, read the section titled "Introduction".
What's confusing about the page I pointed to, or about my sentence?
Create and use Tagsets.MSOffice2K_x.
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!
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.