topic Re: Substr with length in SAS Programming

Substr with length

David_Billa — Tue, 29 Jun 2021 17:27:04 GMT

I've one variable called CRE and it has value like MIN_[NDIP]_2. Now I want to filter only the values [NDIP] using substr function.

When I tried with the following, it's not producing the desired result. Any help?

substr(cre,5,length(cre)-2)

I want the result only using susbstr function.

Re: Substr with length

PGStats — Tue, 29 Jun 2021 18:08:33 GMT

scan(cre, 2, "_")

Re: Substr with length

PaigeMiller — Tue, 29 Jun 2021 18:56:43 GMT

What is the incorrect result that you are getting?

Can you provide a small portion of your data set following these instructions? Because obviously when you manually type a character string in a line of text, sometimes the full information is lost about what this character string really is (for example there may be non-printing characters).

I want the result only using susbstr function.

I reserve the right to give other answers, to propose simpler methods, especially for the benefit of others who might be reading along, and I think @PGStats has nailed it.

Re: Substr with length

Tom — Tue, 29 Jun 2021 18:15:31 GMT

@David_Billa wrote:

I've one variable called CRE and it has value like MIN_[NDIP]_2. Now I want to filter only the values [NDIP] using substr function.

When I tried with the following, it's not producing the desired result. Any help?
substr(cre,5,length(cre)-2)
I want the result only using susbstr function.

Your arithmetic is wrong. You need also subtract the 4 characters you skipped by starting in column 5.

733  data test;
734    x='MIN_[NDIP]_2    ';
735    len=length(x);
736    want=substr(x,5,len-4-2);
737    put (_all_) (=/);
738  run;

x=MIN_[NDIP]_2 
len=12 
want=[NDIP]

Re: Substr with length

Kurt_Bremser — Tue, 29 Jun 2021 18:53:01 GMT

@David_Billa wrote:

...

I want the result only using susbstr function.

Maxim 14.