topic Re: Understanding the output return by the below in SAS Programming

Understanding the output return by the below

shahsn11 — Wed, 25 Jul 2018 04:36:22 GMT

Hi Pals,

Below is a peice of code i am trying to understand Index function. according to me both are almost same code and should return the same result, but that is not the case. Could anybody help me understand the working of the code.

data _null_;
   length a b $14;
   a='ABC.DEF (X=Y)';
   b='X=Y';
   q=index(a,b);
   put q=;
run;

*proc contents data=test3 ;
*run;

data _null_;
   a = 'ABC.DEF (X=Y)';
   b = 'X=Y';
   x = index(a,b);
   put x=;
run;

Re: Understanding the output return by the below

ChrisNZ — Wed, 25 Jul 2018 04:52:41 GMT

The documentation is just one click away!

Functions and CALL Routines: INDEX Function - 9.2

Both leading and trailing spaces are considered part of the excerpt argument. To remove trailing spaces, include the TRIM function with the excerpt variable inside the INDEX function.

The string 'X=Y ' is not found in variable A.

Re: Understanding the output return by the below

shahsn11 — Wed, 25 Jul 2018 06:16:52 GMT

Hi Chris,

Thanks for the quick response.

But, If we see both the data step code I have written and value in variable a and b are same. The second one gives me correct answer but the first one does not.

I would like to understand this behavior why the second result is giving me correct answer and first one is not. If I comment the length code in first datastep I get the correct answer , but I am not able to understand the logic behind this.

Thanks.

Re: Understanding the output return by the below

ChrisNZ — Wed, 25 Jul 2018 06:37:42 GMT

The logic is in my answer. When you don't define a length there are no trailing spaces added to the value you assign.

Re: Understanding the output return by the below

andreas_lds — Wed, 25 Jul 2018 06:39:33 GMT

@ChrisNZ already explained why the index function in the first step fails to find the string: the variable b is always 14 chars long and padded with blanks, not matter what value is assigned to it. If you don't use length (or attrib) to define a variable, its length is automatically set depending on the first use.

Re: Understanding the output return by the below

shahsn11 — Wed, 25 Jul 2018 07:23:27 GMT

Thanks Chris and Andrea for answering the question ... It makes complete sense now ...appreciate the help in clearing the doubt.