ERROR 65-58: Name 'ICOALESCED_CTR_LVL_ENT_FAC_EXCL_IND' is too long for a SAS name in this context

[buechler66]

Has anyone encountered an error like this before?  I find it rather cryptic.  Any possible solutions would be appeciated.

157 + proc sql;
157 + create table QueryData54 as ( select DISTINCT 'INVLD CTR LVL ENT FACILITY EXCL INDICATOR
MISMATCH' as RULE_NM length = 58, b.actual_dlvry_date as AD_DT, b.imb_code length = 31, 54
as RULE_ORDER,
158 + b.spm_calc_batch_date from iv_ora.bi_spm_piece_recon a, bids_ora.bi_spm_piece_recon b
where a.spm_calc_batch_date = b.spm_calc_batch_date and a.imb_code = b.imb_code and COALESCE
NOTE: Line generated by the CALL EXECUTE routine.
159 +(A.ICOALESCED_CTR_LVL_ENT_FAC_EXCL_IND ,'T') <> COALESCE(B.ICOALESCED_CTR_LVL_ENT_FAC_EXCL_IND ,'T') );
----------------------------------- -----------------------------------
65 65
NOTE: The "<>" operator is interpreted as "not equals".
ERROR 65-58: Name 'ICOALESCED_CTR_LVL_ENT_FAC_EXCL_IND' is too long for a SAS name in this context.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
 
ERROR: File WORK.QUERYDATA54.DATA does not exist.
NOTE: Statements not processed because of errors noted above.

[Loko · Accepted solution]

Hello,

It is not weird at all - The length of ICOALESCED_CTR_LVL_ENT_FAC_EXCL_IND is greater than 32 which is the maximum length accepted by sas

[buechler66]

Thank you.

[taylorjessica]

so how do you fix it if the error message comes up when you are trying to load a sas data set?

[Jayank]

But what is the solution of it