Excel Layout of Tables

[TashaBee]

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.

[ballardw]

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)

[TashaBee]

I am using SAS Add-in for Excel. Unfortunately my original file broke and is not working so I did a quick remake.

PROC TABULATE
DATA=_TEMP.ce_nursing_assistant_course

;

VAR CE_STUDENTS;
CLASS COLLEGE_NM / ORDER=UNFORMATTED MISSING;
CLASS REPORTING_YEAR / ORDER=UNFORMATTED MISSING;
CLASS MASTER_COURSE_LIST_ID / ORDER=UNFORMATTED MISSING;
TABLE /* Page Dimension */
MASTER_COURSE_LIST_ID,
/* Row Dimension */
COLLEGE_NM
ALL={LABEL="Total"},
/* Column Dimension */
REPORTING_YEAR*
  CE_STUDENTS*
    Sum   ;
;

RUN;