SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Excel Layout of Tables

Reply
Contributor
Posts: 24

Excel Layout of Tables

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.

imgae1.PNG

image2.PNG

Super User
Posts: 11,114

Re: Excel Layout of Tables

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)

Contributor
Posts: 24

Re: Excel Layout of Tables

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;

Ask a Question
Discussion stats
  • 2 replies
  • 325 views
  • 0 likes
  • 2 in conversation