BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

Check the output in url:
http://support.sas.com/samples_app/00/sample00943_1_odsrep2.htm

For code access url:
http://support.sas.com/ctx/samples/index.jsp?sid=943&tab=code

Check the Sub total label for each region.
Label is as 'TOTAL'
If we give the label as "Total for Region :" || region

Then is displays Total for Region : NC

But problem is that the total label wraps within that cell

I want to span the total label to the next cell and should not wrap within the cell nor the column width should increase.

Please help
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi,
Your choices are to have the Group Break "live" within the width of the column it's in (as in the "Total" report line) or to have the customized line span the WHOLE table (as in the "NC Region -- Sales Need Improvement" line). Those are your choices.

There is no ability to have the "Total" cell merge with the cell next to it. If your customized text is not wide enough to fit the cell width, it will wrap. That cell width can be made wider for the WHOLE column, but since a TABLE is a TABLE is a TABLE -- with the same number of COLUMNS on every ROW (with the exception of LINE statement rows), you cannot merge the TOTAL cell in the REGION column with the CITYSIZE column next to it.

The exception is the LINE statement line. But, as you see, that LINE spans the WHOLE table. That is the way it works. In the LISTING destination, you may be able to place that LINE text so it "looks" like your text string is spanning both REGION AND CITYSIZE, but that look is achieved with the use of "print position" placement of text
[pre] LINE @5 'Total' @23 temptot; [/pre]
That kind of LINE statement only works for LISTING or OUTPUT WINDOW or ASCII text file output. But, that kind of LINE statement is also affected by the LINESIZE option and unless you use the same LINESIZE all the time, the placement from your LINE statement might not line up from data file to data file.

Also, remember that if you are returning reports to Web Report Studio in the BI platform, that LINE statement output does not currently get surfaced in the SASReport XML that WRS uses.

You seem to have a very particular need to have fixed column widths everywhere except the subtotal report row. Your best bet for help with this is to contact Tech Support. They can help you figure out the best technique, if possible, for your output destination of choice (HTML, LISTING). It's possible that you might get a slightly different look using PROC TABULATE, but there you do not thave the ability to put the region name in the TOTAL line.

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 1 reply
  • 588 views
  • 0 likes
  • 2 in conversation