"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
Is this coming from PROC TABULATE (or the Summary Tables task)? Can you post the generated SAS program (or the code you wrote)?
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
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.
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.
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.