BookmarkSubscribeRSS Feed
GertG
Calcite | Level 5
Hi

If you make a three dimensional table i proc tabulate, and use tagsets.tableeditor as output destination, the page dimention text is omitted from the output.

For example:

ods tagsets.tableeditor file='c:\temp\test.html' style=sasweb
options(pageheight="80%"
scrollbar_color="#f1f0ea"
frozen_headers="yes"
frozen_rowheaders="yes");

proc tabulate data=sashelp.class;
class sex name;
var age;
table sex='Sex: ',
(name=' ' all='All'),
age*mean=' '
/box='Test';
run;

ods tagsets.tableeditor close;

Is there a way to display the text for the page dimension?
4 REPLIES 4
Cynthia_sas
SAS Super FREQ
Hi:
I would recommend opening a track with Tech Support, since the same code in the HTML destination does show the page dimension information. Either the TAGSETS.TABLEEDITOR developer intended this behavior, or it is an issue that needs to be fixed. Tech Support is in a position to figure out which is the case.

To open a track with Tech Support, fill out the form at this link:
http://support.sas.com/ctx/supportform/createForm

Otherwise, one workaround would be to use the #BYVAL/#BYVAR information in a TITLE statement with BY group processing to avoid using the page dimension in your TABULATE code. Something like what's shown below this post.

cynthia
[pre]

proc sort data=sashelp.class out=class;
by sex name;
run;

ods tagsets.tableeditor file='c:\temp\test3.html' style=sasweb
options(pageheight="80%"
scrollbar_color="#f1f0ea"
frozen_headers="yes"
frozen_rowheaders="yes");

options nobyline;
title '#Byvar1: #Byval1';
proc tabulate data=class;
by sex;
class name;
var age;
table (name=' ' all='All'),
age*mean=' '
/box='Test';
run;

ods tagsets.tableeditor close;
options byline;
title;
[/pre]
Peter_C
Rhodochrosite | Level 12
GertG

the page dimension text appears above the table for me.
I use SAS9.2 and the version of tagsets.tableeditor is
V2.2.8 3/1/2008
Which versions have you?

peterC
GertG
Calcite | Level 5
Hi peterC

I user SAS9.1.3.
I don't know the version number of the tagset - but it is downloaded from the SAS-site a few days ago, so I suppose i it the latest version.

Regards GertG
Cynthia_sas
SAS Super FREQ
Hi:
Look in the SAS log for this line:
[pre]
1279 ;
NOTE: Writing TAGSETS.TABLEEDITOR Body file: c:\temp\xxxxx.html
V2.40 9/24/2010
[/pre]

I observe the same behavior (no page identifier) when I use the above version of TAGSETS.TABLEEDITOR and SAS 9.2. If Peter C. does not observe the same behavior in the earlier version of the tagset template, then this would be a reason to open a track with Tech Support. Clearly, something changed between the previous version of the template and this newest version of the template.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 4 replies
  • 980 views
  • 0 likes
  • 3 in conversation