Hi: I'm not in a place to run code, now, or write code, but you should be able to figure out much of what you want to do Here's what you asked and my comments: 1. How to rotate the values. -- you will have to look up whether there is an MSO format you can use with TAGATTR and TAGSETS.EXCELXP to perform the rotation on the REGION value -- I'm not sure there is one or there might be, but you have to search for it in the doc. I seem to remember a ROTATE attribute for the TAGATTR suboption (illustrated here: https://support.sas.com/rnd/base/ods/odsmarkup/TipSheet_ods_xl_xp.pdf 2. I need to insert a blank column in Column A (First column for better appeal). By default, when you use TAGSETS.EXCELXP, all output starts in column A in Excel. You could make a "fake" variable that would be blank to force everything to start with column B, but that is hardly worth it. You have Center_horizontal turned on for printing so when/if they print, the output will be centered. If you add a fake column A, then with your Center horizontal setting, you will also be centering the fake column, which might make the output look uncentered. I do not fiddle with Excel this much so I don't have examples of these techniques, but other people might.. 3. How to outline the title 1 as in the attachment (Row 2). I think that you would need to change the STYLE template you're using for this output and, I should warn you that, frequently, ODS ignores borderlines around titles, so this might not work as you envision. I believe you have to change the TitleContainer element and the SystemTitle element, but you'll have to be careful because the higher numbered titles inherit attributes from the SystemTitle element, so you will have to define one style for Title1 and another style for the others. But again, I'm not sure that Excel will respect the border on the title. 4. How to get the sub-total in the column C (product column) without displaying the region name in the column B(region column). I tried using the below but got Region name displayed in the column B. Please avoid the Excel terminology to explalin what you need to do with SAS code. Right now, by default, when rendered in Excel, the output will have REGION in Column A and will have PRODUCT in Column B. You can't change that yet. So there's no point, yet, in confusing the issue by referencing the columns by the names you WANT them to be. And it's also confusing to the new programmer because the columns you deal with in SAS are named REGION and PRODUCT not Column A, Column B and Column C. You can move the "Total" string to the Product column. Assuming you have a BREAK AFTER REGION statement, you can use a COMPUTE block at the break to change the string at the break. Right now, you have REGION='Sub-total' and in your new compute block, you would have PRODUCT='Sub-total'. There are examples of this kind of COMPUTE block in previous forum postings. I'm sure you'll find some if you search for them. The PROC REPORT documentation has good examples, too. cynthia
... View more
