Hi, I'm using Sas 9.1.3, with Excelxp tagsets from 2005 (maybe I need a new version). I have a dataset generated by proc summary that I am using wiht proc report to output to Excel. Thep problem I have is controlling the alingnment of the header boxes. Attached is a one page pdf displaying a sample desired output. For instance, I would like the "family characteristic" header to be one merged box with the text centered, and then have the "percentage of families saved" and "percentage of familes" headers reach all the way to the year spanned header. Currently the way I do it has two blank cells at the top of the cell since there are two spannings (the year and the 'income' header above the mean and median); also since I set 'income' to span there is a blank cell at the top of the percentage of families header cells. In the table below (illustrating my output) the two cells under 1998 would actually be merged in my output and contain the word 'income' I just can't get it to do this in the table in this discussion. Header 1 1998 Family characteristic Median Mean Here is the column statement I am using: COLUMN LABEL YEAR, (('Income' INCOME_MEAN INCOME_MEDIAN) PERCENT_SAVING PCT_FAMILIES); where label is a character variable label for each row, whose header title is "family characteristic". I have searched a lot online and can't find anywhere where it mentions something like this. I have also not seen examples of similar output in papers. The closest I can find is where you can 'erase' the gridlines by making them white using DDE but this wouldn't help me center the header title within the 'merged' cell, also I am using linux which appears not to work with DDE, and I think these features are new to SAS 9.2. Any tips? Or am I just wasting my time trying to do this?
... View more