If you are running at least 9.4M1, then Proc GEOCODE will return the ZIP Code used in the results in M_ZIP.  So, while ZIP is 48999, M_ZIP will be 48009.  You can look at the variable _NOTES_.  If it contains NOZCM (No Zip Code Match) then the ZIP Code given by "you" does not match the ZIP Code of the address (city and state). ... View more

A MERGE without a BY merges the records in their physical order in the datasets. And yes, the same dataset can be used more than once in a SET or MERGE statement in a DATA step. Care needs to be taken with the variables by properly KEEPing and RENAMEing them, so you don't get unexpected overwrites. What I do is I use the LAG() function to get previous values, while reading the same dataset starting at obs=2 gives me the "peek ahead". ... View more

Great idea. Thanks again. ... View more

Thank you for your help. I love this forum. ... View more

@jnvickery, @UMAnalyst You need to change the code as below using a retain statement for "patternID" as else a new version of the RegEx will get compiled in every single iteration of the data step. This is not only unnecessary and very inefficient it also clutters memory. data OUT; set IN; retain patternID ; if _n_=1 then patternID = prxparse('/(\d+)$/'); call prxsubstr(patternID, trim(ADDRESSVAR), position, length); put position= length=; run; ... View more