03-25-2015 03:13 PM
Is there a way to adjust how the layout of the tables in Excel?
This is a snapshot of an Excel file that I used to with the Summary Table Task and the tables are placed anywhere in the worksheet, some with numerous pages.
03-25-2015 05:27 PM
Which version of EG?
You may need to find the code generated by the tasks and modify it as the more control over output the more custom programming not available through wizards and such is required.
If you post the code generated we might be able to provide some help.
A possible simple item MIGHT be setting that centering of output is off so all the tables are left justified (start in column 1)
03-27-2015 10:32 AM
I am using SAS Add-in for Excel. Unfortunately my original file broke and is not working so I did a quick remake.
CLASS COLLEGE_NM / ORDER=UNFORMATTED MISSING;
CLASS REPORTING_YEAR / ORDER=UNFORMATTED MISSING;
CLASS MASTER_COURSE_LIST_ID / ORDER=UNFORMATTED MISSING;
TABLE /* Page Dimension */
/* Row Dimension */
/* Column Dimension */