BookmarkSubscribeRSS Feed
RPYee
Quartz | Level 8

"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

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

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

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
RPYee
Quartz | Level 8

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

 

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
ballardw
Super User
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.

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2203 views
  • 1 like
  • 3 in conversation