topic Re: Substr statement in SAS Programming

Substr statement

ybz12003 — Wed, 27 Apr 2016 17:58:54 GMT

Hi, all:

I found these codes written from previous programmer. Is it the (1,length(indicator)-1) in IND and (length(indicator),1) in TYPE are the same? Please help. Thanks.

IND=substr(INDICATOR,1,length(indicator)-1);

TYPE=substr(INDICATOR,length(indicator),1);

Re: Substr statement

PGStats — Wed, 27 Apr 2016 18:15:00 GMT

IND is the whole string except the last character

TYPE is the last character

Re: Substr statement

ybz12003 — Wed, 27 Apr 2016 19:11:34 GMT

I don't quite understand why TYPE is the last character.

Re: Substr statement

ybz12003 — Wed, 27 Apr 2016 19:27:27 GMT

SUBSTR( ) Used on Right Side on Assignment Statement.

SYNTAX:

=SUBSTR (char_string, start_position,no_of_chars_to_read );

extracts char string from start position and with length given.

In that mean, TYPE is starting the whole length of "INDICATOR", and only extract the last number? right?

Re: Substr statement

PGStats — Wed, 27 Apr 2016 19:37:38 GMT

For example, "ybz12003" has length 8, so the string of length 1 starting at position 8 is "3".

Re: Substr statement

ybz12003 — Wed, 27 Apr 2016 23:36:58 GMT

Thanks