topic Re: Substr in SAS Programming

Substr

PurushReddy — Wed, 16 Mar 2022 06:51:01 GMT

I am not understanding below program how it resolved
Data a;
Input string 7.;
Reverse=reverse (string);
pos=indexc(reverse,"., ");
Last_word=substr (string,7-pos+2);
Cards;
ABC.DEF
JHG GHTY
HYT,XYZ
;
RUN;
HERE LAST_WORD STATEMENT HOW IT WILL RESOLVE, PLEASE EXPLAIN

Re: Substr

LinusH — Wed, 16 Mar 2022 07:29:31 GMT

Insert a put _all_; statement

Run the program.

Examine log.

Re: Substr

Rick_SAS — Wed, 16 Mar 2022 10:24:07 GMT

I think you want to declare String to be a CHARACTER variable. Currently, it is a numeric variable. To declare a character variable, put a '$' symbol after the name of the variable on the INPUT statement, like this:

Input string $ 7.;

After making that change, rerun the program and examine the output. Let us know if you still have questions!

Re: Substr

PurushReddy — Wed, 16 Mar 2022 10:29:59 GMT

Thanks for your response,
I want to know how this is working,means flow
Last _word=Substr(string,7-pos+2);

Last _word=Substr(string,7-p+2)

PurushReddy — Wed, 16 Mar 2022 10:41:45 GMT

flow of work
Last _word=Substr(string,7-pos+2);
*7-pos+2(here pos value:4)*

Re: Substr

Rick_SAS — Wed, 16 Mar 2022 10:54:23 GMT

The doc is your friend. Here is a link to the SUBSTR doc.

pos = the location of a delimiter in the reverse string. The delimiters are '.' or ',' or ' '.
Each string in your data is 7 characters long, so 7-pos gives the position of the character BEFORE the delimiter.
Therefore 7-pos+2 gives the position of the character AFTER the delimiter.
The SUBSTR function copies all characters from that position until the end of the string.

Re: Last _word=Substr(string,7-p+2)

maguiremq — Wed, 16 Mar 2022 11:10:24 GMT

What determines `pos`? Please provide some example data.

Re: Last _word=Substr(string,7-p+2)

PaigeMiller — Wed, 16 Mar 2022 11:42:44 GMT

@PurushReddy wrote:
flow of work
Last _word=Substr(string,7-pos+2);
*7-pos+2(here pos value:4)*

What is your question?

Re: Last _word=Substr(string,7-p+2)

Kurt_Bremser — Wed, 16 Mar 2022 12:15:30 GMT

I moved your erroneous post in here.

Re: Last _word=Substr(string,7-p+2)

PurushReddy — Wed, 16 Mar 2022 12:16:57 GMT

Substr(string,7-pos+2),
How this is working, I am not getting, what is the flow of.

Re: Last _word=Substr(string,7-p+2)

PurushReddy — Wed, 16 Mar 2022 12:19:18 GMT

Actually this is total dataset, I want to know how(Last_word=substr (string,7-pos+2);).

Data a;
Input string 7.;
Reverse=reverse (string);
pos=indexc(reverse,"., ");
Last_word=substr (string,7-pos+2);
Cards;
ABC.DEF
JHG GHTY
HYT,XYZ
;
RUN;

Re: Last _word=Substr(string,7-p+2)

Kurt_Bremser — Wed, 16 Mar 2022 12:23:16 GMT

@Rick_SAS has already provided your answer.

Re: Substr

Kurt_Bremser — Wed, 16 Mar 2022 12:31:39 GMT

Your task can be much easier solved by using the right tool (Maxim 14), which is the SCAN function:

data a;
input string $7.;
last_word = scan(string,-1,"., ");
cards;
ABC.DEF
JHG GHTY
HYT,XYZ
;