Hello Tom,
I will describe a new example.
I use, as example, the following dataset: SASHELP.CLASS. From this dataset I want the next report: Total-Weight and Total-Height summed by Age, in Euro's with no decimals. The format I will use is NLMNLEUR12.0 To create the reports I use Enterprise Guide with 2 tasks: - Summary Tables Wizard... - Summary Tables...
First the Summary Tables Wizard task; see attachment "Summary Tables Wizard Class-table definition".
After RUN in EG shows as result the following attachment: "Summary Tables Wizard Class-table Result."
The LOG from this proces: "Proc Tabulate Data=SASHELP.CLASS FORMAT=NLMNLEUR12.0; VAR HEIGHT WEIGHT; CLASS Age / ORDER=UNFORMATTED MISSING; TABLE /* ROW statement */ Age all = 'Total' , /* COLUMN Statement */ (Height * Sum={LABEL="SUM"} Weight * Sum={LABEL="Sum"} ) ; RUN;
Second: the Summary Tables task; first the attachment which shows the Selected Format "NLMNLEUR12.0": "Summary Tables task format"; running this task results in the following attachment "Summary Tables task result", in which you see decimal-values (that is not what we want!); back to the task-window and we see that the format has changed into NLMNLEUR12.2., see attachment "Summary Tables task format after run".
The LOG from this proces: "Proc Tabulate Data=SASHELP.CLASS; VAR HEIGHT WEIGHT; CLASS Age / ORDER=UNFORMATTED MISSING; TABLE /* ROW Dimension */ Age * Sum*F=NLMNLEUR12. Sum*F=NLMNLEUR12. /* Column Dimension */ Height Weight ; ; RUN; Remark : this is strange, in the Proc Tabulate the format has NO decimals (12.) and in the task it shows 2 decimals (12.2)
I hope it's clear what I wrote and you have a sulution for it.
With my sincere regards, Jan Sijm
... View more