topic Re: substr 6 digits after comma in SAS Programming

substr 6 digits after comma

selchen — Tue, 17 Nov 2020 09:21:08 GMT

Hi everyone,

im a beginner and i try to substr some adresses.

Result should be cutted aber 6 digits after the comma.

input

Musterstr. 1b, 12345 Musterstadt

output:

Musterstr. 1b, 12345

i tried

substr (t1.adress, findc (t1.adress,",")-0)

any ideas how to solve to start the substr 6 digits after the comma?

thanks for your help.

PeterClemmensen — Tue, 17 Nov 2020 09:25:27 GMT

Try this

data test;
   str = 'Musterstr. 1b, 12345 Musterstadt';
   new = substr(str, 1, find(str, ',') + 6);
run;

PeterClemmensen — Tue, 17 Nov 2020 09:31:07 GMT

Also, a PRXCHANGE Approach.

hope this helps 🙂

data test;
   str = 'Musterstr. 1b, 12345 Musterstadt';
   new = prxchange('s/(.*,.{6})(.*)/$1/', -1, str);
run;

selchen — Tue, 17 Nov 2020 09:31:29 GMT

thanks a lot. it is working.

PeterClemmensen — Tue, 17 Nov 2020 09:32:21 GMT

Anytime 🙂