topic Re: Warning: Dimension crossing has multiple format modifiers in SAS Enterprise Guide

Warning: Dimension crossing has multiple format modifiers

RPYee — Fri, 15 Dec 2017 13:59:27 GMT

"Warning: Dimension crossing has multiple format modifiers"

I am receiving the above warning in my log file. It puts a little exclamation point on the icon for that section of the program. Being very OCD, I hate the little exclamation point 🙂

Any ideas? What can I post to help identify the source of the warning?

Being sooooo new to SAS is frustrating when it comes to troubleshooting. I appreciate everyone's patience 🙂

Rita Yee

Project Engineer

FedEx Express - Global Trade Services

Re: Warning: Dimension crossing has multiple format modifiers

ChrisHemedinger — Fri, 15 Dec 2017 14:01:11 GMT

Is this coming from PROC TABULATE (or the Summary Tables task)? Can you post the generated SAS program (or the code you wrote)?

Re: Warning: Dimension crossing has multiple format modifiers

RPYee — Fri, 15 Dec 2017 15:30:48 GMT

I am using the GUI. The warning is in the summary definition. I think this is the correct code:

TITLE;

TITLE1 "Count of Cage Reason Uses";

FOOTNOTE;

FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";

/* -------------------------------------------------------------------

Code generated by SAS Task

Generated on: Friday, December 15, 2017 at 8:59:02 AM

By task: Summary of top Cage Reasons

Input Data: SASApp:WORK.QUERY_FOR_CAGE_PIECE_FACT

Server: SASApp

------------------------------------------------------------------- */

/* -------------------------------------------------------------------

Run the tabulate procedure

------------------------------------------------------------------- */

PROC TABULATE

DATA=WORK.QUERY_FOR_CAGE_PIECE_FACT

;

VAR COUNT_DISTINCT_of_AIRBILL_WNBR;

CLASS CAGE_REASON_CD / ORDER=UNFORMATTED MISSING;

CLASS WEEK_FLAG / ORDER=UNFORMATTED DESCENDING MISSING;

CLASS LOCATION_CD / ORDER=UNFORMATTED MISSING;

TABLE /* Row Dimension */

CAGE_REASON_CD*

COUNT_DISTINCT_of_AIRBILL_WNBR*F=COMMA19.*

Sum*F=COMMA8.,

/* Column Dimension */

WEEK_FLAG*

LOCATION_CD

WEEK_FLAG

/*Table Options */

/ MISSTEXT="0" ;

;

RUN;

/* -------------------------------------------------------------------

End of task code

------------------------------------------------------------------- */

RUN; QUIT;

TITLE; FOOTNOTE;

I'll be glad when I know what I'm doing 🙂

Rita

Re: Warning: Dimension crossing has multiple format modifiers

ballardw — Fri, 15 Dec 2017 15:56:41 GMT

proc tabulate data=sashelp.class;
   class age;
   var height;
   table age,
         height *sum*f=best4.;
run;

The problem comes from what ever generated this snippet:

COUNT_DISTINCT_of_AIRBILL_WNBR*F=COMMA19.*

When a variable is a VAR variable the only formats should be associated with the statistic as VAR does not show individual values of the variable.

proc tabulate data=sashelp.class;
   class age;
   var height;
   table age,
         height*f=f3.2 *sum*f=best4.;
run;

will duplicate your warning message but

proc tabulate data=sashelp.class;
   class age;
   var height;
   table age,
         height *sum*f=best4.;
run;

Notice the result will be the same as the Proc Tabulate call with the improper format just ignores it.