BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I am using proc tabulate and am fairly new to it. I can get the main part of my table looking they way I want it. My problem is with the width of the column containing the row labels. One of the labels is 03. Adverse Internal & OII. When this is displayed in my output it displays one word per line so that there is a very large box so that the numbers in the table look very small with lots of blank space.

I need to be able to make the column wider but struggling to find the code.

Thanks in advance for your help.
2 REPLIES 2
Bill
Quartz | Level 8
Alan;

If you would post the code that you have it would be easieer for some one to show you how to tweak it

wd
Cynthia_sas
SAS Super FREQ
Hi:
Generally, the "row" labels are controlled by the row title space setting, which in the LISTING destination or OUTPUT window is set to 1/4 of line size. So, if you are talking about the LISTING window output, then try either of these things:
1) increase your linesize to 160:
[pre]
options ls=160;
[/pre]

before the TABULATE and see if that helps. If it does help but not enough, then do this in your TABLE statement:
[pre]
table var1 ,
var2*(min mean max) / rts=30;
[/pre]

Note the slash after your last variable and statistic specification and then the RTS option (after a slash). The RTS option should be as long as your string, plus 2 -- so if your string is 28 characters including spaces, then your RTS value would be 30. This extra number is taking into account the divider line at the beginning of the row cells and the divider after the row cells.

If you are NOT talking about the LISTING destination or OUTPUT window, then you should either paste your code into your forum posting and tell us your destination of choice (HTML, RTF, PDF, LISTING) -- because RTS only works for the LISTING window and you would have to use the CELLWIDTH style attribute to change the width of the row title area for other destinations.

Your other option is to try Tech Support who can look at your code AND your data and can help you with your question.

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