I am trying to use SAS to generate some flash financial statements from an Oracle database. I have the data pulled and presented correctly (via PROC REPORT), but I can't for the life of me figure out how to put a single line below section totals, and a double line before the grand total. (I know this used to be the UL and DUL functions, but these aren't recognized by ODS PDF, which is the intended format.) What I want to have is basically lines like the following:
25,000 Office expense
50,000 Consultant expense
75,000 Total expenses
3,925,000 Net income
I've tried putting a border on the total row, but it extends all the way across the page. Is there something I'm missing?
Thanks for the help!
Controller, Lake Superior State University
It would help to see your whole ODS PDF invocation, including the STYLE= option that you're using. In some sense, adding underlines would be a bit redundant because the default PDF style has table lines all over the place.
There are some examples of using RTF control strings in that posting too. No matter whether the code examples are using TEXTDECORATION or BORDERBOTTOMSTYLE, you might want to experiment with the JOURNAL style -- instead of the default PDF style because JOURNAL will remove all of the interior table lines except the ones under the headers and the text decoration or border style that you add.
Thanks, Cynthia. TEXTDECORATION is close, but I want both an overline and an underline. BORDER is close, but the border goes completely across the page (I just want it with the numbers, not under the text headings at left).
I'm importing a CSS file based on the EGDefault template from the Enterprise Guide. I'm pasting both it and my code below. Any guidance is definitely appreciated!!
I believe the behavior you're seeing is the expected behavior with the border styles. Essentially, the border of each cell is "bumping into" the border of the adjacent cell. The fact that your border line spans the entire table (even under your row values for EXPCAT) is a function of putting the border style on the BREAK and RBREAK statements. What happens on those statements, style-wise, has an impact on the ENTIRE report row written by the BREAK or RBREAK statement -- not just on the numbers written as a result of the break. After all, the entire report row, including the blanks for EXPCAT are written as a result of the BREAK or RBREAK statement.
You might be able to remove the border lines under EXPCAT if you attached your style to the CY_AMT and PY_AMT variables in a CALL DEFINE statement -- however, I believe that the borders for each cell for your numeric variables would still touch each other....making it look like a solid border under all the totalled numbers.
BTW, some of your coding choices, such as SKIP fall into the same category as DOL/DUL/OL/UL -- SKIP is a LISTING only destination option. So, to get a blank line after your break for REVEXP, you would need:
compute after revexp;
line ' ';
You may want to work with Tech Support, if TEXTDECORATION of OVERLINE does not work for you. (I can't remember whether all TEXTDECORATION possible values work in all destinations.)