topic Re: How to update sashelp.zipcode in SAS Programming

How to update sashelp.zipcode

jerry898969 — Thu, 19 Jan 2017 16:57:39 GMT

Hello,

I working on geocoding some data and the process runs and sasy that the zip lookup data is sashelp.zipcode.

So I went and retrived the latest file from SAS's website and I want to update the sashelp.zipcode file with the latest version so my geocoding is done with the latest version.

I have tried doing the following and creating a backup of the current zipcode file, but I keep getting an error.

data sashelp.zipcode_old ;
set sashelp.zipcode ;
run ;

ERROR: User does not have appropriate authorization level for library SASHELP.

I'm using SAS 9.4 TS1M2 on a windows 7 computer. I have already given myself write permissions on

C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp and it still gives me an error.

Thank you

Re: How to update sashelp.zipcode

art297 — Thu, 19 Jan 2017 17:08:00 GMT

While dangerous, I've always made the change directly to the actual sashelp file. Of course, I always keep a copy of the original so I can re-instate it if what I change/add doesn't work.

As such, in SAS, I create a new copy of zipcode file in a permanent library that I have read/write access, I make the desired additions to that file.

Then, I exit SAS and, from Window's Explorer, move that file into the sashelp directory. If it is the first time I;m doing it, first (also in Window's Explorer) I make a copy of the sashelp.zipcode file in the sashelp directory, calling it sashelp_original.

HTH,

Art, CEO, AnalystFinder.com

Re: How to update sashelp.zipcode

jerry898969 — Thu, 19 Jan 2017 17:33:11 GMT

Art,

Thank you so much. That solution worked perfect.

I created a backup and copied over the new version of the data and then opened sas and the new version was there.

Thank you,

Jerry