topic Re: String manipulation in SAS Programming

String manipulation

Go210 — Mon, 30 Apr 2018 08:00:27 GMT

Hi all I am new to sas.

I hope you can help.

I am trying to break up a strings to receive the last group of digits contained within the string.

Eg1 my string
"#113#468#9999#2474#.#.#.#.#"

Result
2474

Eg2

"5743#788#1#9#89999#64#68#.#.#"

Result
68

Thanks in advance.

Re: String manipulation

Go210 — Mon, 30 Apr 2018 08:01:18 GMT

Note the last character could be a number or a .

Re: String manipulation

RW9 — Mon, 30 Apr 2018 08:07:51 GMT

Well:

data want;
  set have;
  do i=1 to countw(mystring,"#");
    if scan(mystring,i,"#") ne "." then last_num=scan(mystring,i,"#");
  end;
run;

Re: String manipulation

PeterClemmensen — Mon, 30 Apr 2018 08:17:59 GMT

are your digits always surrounded by ##?

Re: String manipulation

PeterClemmensen — Mon, 30 Apr 2018 08:33:12 GMT

An alternative..

data have;
    length string $100;
    string="#113#468#9999#2474#.#.#.#.#";output;
    string="5743#788#1#9#89999#64#68#.#.#";output;
run;

data want;
    set have;

    to=anydigit(string, -length(string));
    from=notdigit(string, -to)+1;

    num=substr(string, from, to-from+1);
run;

Re: String manipulation

Patrick — Mon, 30 Apr 2018 08:58:11 GMT

@Go210

Below should do the job.

data have;
  length string $100;
  string="#113#468#9999#2474#.#.#.#.#";output;
  string="5743#788#1#9#89999#64#68#.#.#";output;
  string="#.#.#";output;
  string="#.#.#123";output;
  string="456#.#.#";output;
run;

data want;
  set have;
  number=input(scan(string,-1,,'kd'),best32.);
run;

Re: String manipulation

Go210 — Mon, 30 Apr 2018 10:09:19 GMT

Thanks for all your help. So many solutions!

Re: String manipulation

novinosrin — Mon, 30 Apr 2018 13:59:48 GMT

No loop needed for your examples, very simple and straight forward-->

data want;
mystring="#113#468#9999#2474#.#.#.#.#";
last_num=scan(compress(mystring,'.'),-1,'#');
output;
mystring="5743#788#1#9#89999#64#68#.#.#";
last_num=scan(compress(mystring,'.'),-1,'#');
output;
run;