SAS Street Geocoding (SAS v9.4)

ndovie — Mon, 16 May 2022 18:51:05 GMT

Hello, in the SAS Street Geocoding guide, it suggests removing extraneous information to improve street geocoding. I would like to remove the apartment or lot number at the end of the address string e.g., “1122 Main St Apt xxx” or “1122 Main St Lot xxx”, resulting in "1122 Main St" to clean these data in preparation for street geocoding. I’m having difficulty with SAS code (below) to do this. Please advise? Thx!

data Test ; set Data1 (keep=address city zipcode state) ;
SUB = '<Apt>';
address = transtrn(STR,SUB,trimn(''));
run;

Re: SAS Street Geocoding (SAS v9.4)

SASKiwi — Mon, 16 May 2022 20:01:25 GMT

data want;
  street = "1122 Main St Apt xxx";
  street_cleaned = substr(street, 1, findw(upcase(street),'APT')-1);
  put _all_;
  street = "1122 Main St Lot xxx";
  street_cleaned = substr(street, 1, findw(upcase(street),'LOT')-1);
  put _all_;
run;

topic Re: SAS Street Geocoding (SAS v9.4) in SAS Programming

SAS Street Geocoding (SAS v9.4)

Re: SAS Street Geocoding (SAS v9.4)