topic Re: Out of Range Warning in SAS Programming

Out of Range Warning

David_Billa — Tue, 21 Apr 2020 06:58:52 GMT

I'm not certain why I get the out of range warning after executing the code below. Am I missing something?

  data _null_;
 if symexist("_CD") then _CD = symget("_CD");
  else _CD = '';
  if symexist("ENTITY") then ENTITY = symget("ENTITY");
  else ENTITY = '';
 le=compress(COALESCEC(_CD,ENTITY));
call symput('le',le);
*drop _:;
run;

Log:

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      
WARNING: Argument 3 to macro function %SUBSTR is out of range.

Re: Out of Range Warning

yabwon — Tue, 21 Apr 2020 07:06:12 GMT

Read the documentation:

Syntax

%SUBSTR(argument, position<, length>)

%QSUBSTR(argument, position<, length>)

Required Arguments

argument

is a character string or a text expression. If argument might contain a special character or mnemonic operator, listed below, use %QSUBSTR.

position

is an integer or an expression (text, logical, or arithmetic) that yields an integer, which specifies the position of the first character in the substring. If position is greater than the number of characters in the string, %SUBSTR and %QSUBSTR issue a warning message and return a null value. An automatic call to %EVAL causes n to be treated as a numeric value.

length

is an optional integer or an expression (text, logical, or arithmetic) that yields an integer that specifies the number of characters in the substring. If length is greater than the number of characters following position in argument, %SUBSTR and %QSUBSTR issue a warning message and return a substring containing the characters from position to the end of the string. By default, %SUBSTR and %QSUBSTR produce a string containing the characters from position to the end of the character string.

All the best

Bart

Re: Out of Range Warning

Kurt_Bremser — Tue, 21 Apr 2020 07:54:58 GMT

Please COPY/PASTE (!!) the WHOLE log. Your code as posted does not contain ANY call of the %substr() macro function.

@David_Billa wrote:

I'm not certain why I get the out of range warning after executing the code below. Am I missing something?

  data _null_;
 if symexist("_CD") then _CD = symget("_CD");
  else _CD = '';
  if symexist("ENTITY") then ENTITY = symget("ENTITY");
  else ENTITY = '';
 le=compress(COALESCEC(_CD,ENTITY));
call symput('le',le);
*drop _:;
run;

Log:

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      
WARNING: Argument 3 to macro function %SUBSTR is out of range.