DATA Step, Macro, Functions and more

How to update sashelp.zipcode

Accepted Solution Solved
Reply
Super Contributor
Posts: 398
Accepted Solution

How to update sashelp.zipcode

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

 


Accepted Solutions
Solution
‎01-19-2017 12:32 PM
PROC Star
Posts: 7,364

Re: How to update sashelp.zipcode

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

 

View solution in original post


All Replies
Solution
‎01-19-2017 12:32 PM
PROC Star
Posts: 7,364

Re: How to update sashelp.zipcode

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

 

Super Contributor
Posts: 398

Re: How to update sashelp.zipcode

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 212 views
  • 0 likes
  • 2 in conversation