Warning: Dimension crossing has multiple format modifiers

[RPYee]

"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

[ChrisHemedinger]

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

[RPYee]

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

[ballardw]

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.