I need to figure out how to find & replace strings in an access database from SAS. I've tried using proc import then prxparse() & prxchange(), but there must be a better/more efficient method. The biggest problem is that I need to find/replace 1200 names in each variable (~20) for 1200 observations.
Any suggestions? At least something to point me in the right direction?