SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Find & Replace string in Access db

Reply
N/A
Posts: 1

Find & Replace string in Access db

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?

Thanks,
Bkmn
Post a Question
Discussion Stats
  • 0 replies
  • 116 views
  • 0 likes
  • 1 in conversation