topic Re: Excel Layout of Tables in Microsoft Integration with SAS

Excel Layout of Tables

TashaBee — Wed, 25 Mar 2015 19:13:45 GMT

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.

Re: Excel Layout of Tables

ballardw — Wed, 25 Mar 2015 21:27:16 GMT

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)

Re: Excel Layout of Tables

TashaBee — Fri, 27 Mar 2015 14:32:37 GMT

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;