cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
syazwaan
‎03-16-2021
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

String Matching

by Calcite | Level 5 in SAS Programming
‎03-11-2021 08:53 PM
‎03-11-2021 08:53 PM
I have 2 datasets (Data and Locality). I want to match string between column 'ADDR1' in first dataset (Data) with 'Locality Name' in second dataset (Locality). The 'Data' dataset contain 800,000+ rows and the 'Locality' dataset contain 2,000+ rows.   Example: ADDR1 Locality Name NO 35 JALAN BUKIT BERUANG TIGA TAMAN BUKIT BERUANG KAMPUNG TERSUSUN SERKAM DARAT LOT 2697 JALAN TIONG KAMPUNG TERSUSUN SERKAM DARAT TAMAN REMBIA SETIA RM 1024 JALAN REMBIA SETIA 5 TAMAN REMBIA SETIA JALAN BUKIT BERUANG RM 713 JALAN SETIA 3 TAMAN REMBIA SETIA JALAN BUKIT BERUANG   Result that I want: ADDR1  Locality Name NO 35 JALAN BUKIT BERUANG TIGA TAMAN BUKIT BERUANG JALAN BUKIT BERUANG LOT 2697 JALAN TIONG KAMPUNG TERSUSUN SERKAM DARAT KAMPUNG TERSUSUN SERKAM DARAT RM 1024 JALAN REMBIA SETIA 5 TAMAN REMBIA SETIA TAMAN REMBIA SETIA RM 713 JALAN SETIA 3 TAMAN REMBIA SETIA TAMAN REMBIA SETIA   Thank you. ... View more

Re: Address Matching

by Calcite | Level 5 in SAS Programming
‎03-11-2021 04:22 AM
‎03-11-2021 04:22 AM
Example: ADDR1 Locality Name NO 35 JALAN BUKIT BERUANG TIGA TAMAN BUKIT BERUANG KAMPUNG TERSUSUN SERKAM DARAT LOT 2697 JALAN TIONG KAMPUNG TERSUSUN SERKAM DARAT TAMAN REMBIA SETIA RM 1024 JALAN REMBIA SETIA 5 TAMAN REMBIA SETIA JALAN BUKIT BERUANG RM 713 JALAN SETIA 3 TAMAN REMBIA SETIA JALAN BUKIT BERUANG   Result: ADDR1 Locality Name NO 35 JALAN BUKIT BERUANG TIGA TAMAN BUKIT BERUANG JALAN BUKIT BERUANG LOT 2697 JALAN TIONG KAMPUNG TERSUSUN SERKAM DARAT KAMPUNG TERSUSUN SERKAM DARAT RM 1024 JALAN REMBIA SETIA 5 TAMAN REMBIA SETIA TAMAN REMBIA SETIA RM 713 JALAN SETIA 3 TAMAN REMBIA SETIA TAMAN REMBIA SETIA ... View more

Address Matching

by Calcite | Level 5 in SAS Programming
‎03-11-2021 03:39 AM
‎03-11-2021 03:39 AM
I have 2 datasets (Data and Locality). I want to match string between column 'ADDR1' in first dataset (Data) with 'Locality Name' in second dataset (Locality). The 'Data' dataset contain 800,000+ rows and the 'Locality' dataset contain 2,000+ rows.   Example: ADDR1 Locality Name NO 35 JALAN BUKIT BERUANG TIGA TAMAN BUKIT BERUANG KAMPUNG TERSUSUN SERKAM DARAT LOT 2697 JALAN TIONG KAMPUNG TERSUSUN SERKAM DARAT TAMAN REMBIA SETIA RM 1024 JALAN REMBIA SETIA 5 TAMAN REMBIA SETIA JALAN BUKIT BERUANG RM 713 JALAN SETIA 3 TAMAN REMBIA SETIA JALAN BUKIT BERUANG   Result that I want: ADDR1  Locality Name NO 35 JALAN BUKIT BERUANG TIGA TAMAN BUKIT BERUANG JALAN BUKIT BERUANG LOT 2697 JALAN TIONG KAMPUNG TERSUSUN SERKAM DARAT KAMPUNG TERSUSUN SERKAM DARAT RM 1024 JALAN REMBIA SETIA 5 TAMAN REMBIA SETIA TAMAN REMBIA SETIA RM 713 JALAN SETIA 3 TAMAN REMBIA SETIA TAMAN REMBIA SETIA   Thank you. ... View more

Remove digit and string after digit

by Calcite | Level 5 in SAS Programming
‎03-08-2021 03:23 AM
‎03-08-2021 03:23 AM
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. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-16-2021 11:32 PM
Quick links