Desktop productivity for business analysts and programmers

Warning: Dimension crossing has multiple format modifiers

Reply
Contributor
Posts: 41

Warning: Dimension crossing has multiple format modifiers

"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 Smiley Happy

 

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 Smiley Happy

 

Rita Yee

Project Engineer

FedEx Express - Global Trade Services

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
Community Manager
Posts: 3,463

Re: Warning: Dimension crossing has multiple format modifiers

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

Contributor
Posts: 41

Re: Warning: Dimension crossing has multiple format modifiers

Posted in reply to ChrisHemedinger

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 Smiley Happy

Rita

 

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
Super User
Posts: 13,942

Re: Warning: Dimension crossing has multiple format modifiers

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.

 

Ask a Question
Discussion stats
  • 3 replies
  • 335 views
  • 1 like
  • 3 in conversation