DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Regular Contributor
Posts: 212
Accepted Solution

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

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.

 


Accepted Solutions
Solution
‎05-19-2016 08:46 AM
Super Contributor
Posts: 305

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

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

 

 

View solution in original post


All Replies
Solution
‎05-19-2016 08:46 AM
Super Contributor
Posts: 305

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

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

 

 

Regular Contributor
Posts: 212

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

Thank you.
Established User
Posts: 1

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

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

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

But what is the solution of it

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 728 views
  • 1 like
  • 4 in conversation