topic Re: ERROR 65-58: Name 'ICOALESCED_CTR_LVL_ENT_FAC_EXCL_IND' is too long for a SAS name in this conte in SAS Programming

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

buechler66 — Thu, 19 May 2016 12:19:44 GMT

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.

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

Loko — Thu, 19 May 2016 12:29:54 GMT

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

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

buechler66 — Thu, 19 May 2016 12:47:03 GMT

Thank you.

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

taylorjessica — Mon, 10 Jul 2017 19:41:32 GMT

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

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

Jayank — Thu, 10 Aug 2017 15:03:57 GMT

But what is the solution of it