topic Remove digit and string after digit in SAS Programming

Remove digit and string after digit

syazwaan — Mon, 08 Mar 2021 08:23:47 GMT

I have some dataset like this:

KAWASAN PERINDTRIAN MASJID TANAH,78300 MASJID TANAH, MELAKA,MALAYSIA

MUKIM SERKAM 77300 MERLIMAU, MELAKA

PAYA MENGKUANG 78300 MASJID TANAH MELAKA

I want to remove the 5 digit postcode and string after postcode.

The output that I want is like this:

KAWASAN PERINDTRIAN MASJID TANAH

MUKIM SERKAM

PAYA MENGKUANG

Thank you.

Re: Remove digit and string after digit

andreas_lds — Mon, 08 Mar 2021 08:42:48 GMT

Is it 100% that only one five-digit-number is in the data? If yes, then try:

data want;
   set have;
   length new $ 100;

   new = prxchange('s/(.*)\W+\d{5}.*/$1/', 1, string);
run;

Re: Remove digit and string after digit

Shmuel — Mon, 08 Mar 2021 08:55:21 GMT

Alternative code:

newvar = substr(string,1,indexc(string,'0123456789')-1);

This code searches for the first digit in string, even if it is not a postcode of 5 digits.

Re: Remove digit and string after digit

Ksharp — Mon, 08 Mar 2021 11:05:05 GMT

data have;
input x $80.;
cards;
KAWASAN PERINDTRIAN MASJID TANAH,78300 MASJID TANAH, MELAKA,MALAYSIA
MUKIM SERKAM 77300 MERLIMAU, MELAKA
PAYA MENGKUANG 78300 MASJID TANAH MELAKA
;
data want;
 set have;
 want=substr(x,1,prxmatch('/\d{5}/',x)-1);
 run;