BookmarkSubscribeRSS Feed
Ihsan-Mahdi
Obsidian | Level 7

Hello,

 

I'm trying to use the code below to create a street address map but I keep getting the error you see in bold red:

proc geocode
27 method=street
28 data=GCTest2
29 LOOKUPSTREET=lookup.USM
30 OUT=GEOCODED
ERROR: Libref LOOKUP is not assigned.
31 ATTRIBUTE_VAR=(countyfp Tract);
32 run;

 

I have used this exact same code before on the same device using the same SAS version and it worked. Not sure what the issue is now and would appreciate the help 🙂

3 REPLIES 3
ballardw
Super User

@Ihsan-Mahdi wrote:

Hello,

 

I'm trying to use the code below to create a street address map but I keep getting the error you see in bold red:

proc geocode
27 method=street
28 data=GCTest2
29 LOOKUPSTREET=lookup.USM
30 OUT=GEOCODED
ERROR: Libref LOOKUP is not assigned.
31 ATTRIBUTE_VAR=(countyfp Tract);
32 run;

 

I have used this exact same code before on the same device using the same SAS version and it worked. Not sure what the issue is now and would appreciate the help 🙂


If that code worked previously then you have a LIBRARY named LOOKUP assigned in that session. Your current session does not. That's what "Libref LOOKUP is not assigned" means.

If you want to use the same data set then you need a LIBNAME LOOKUP pointing the location of that data set.

Ihsan-Mahdi
Obsidian | Level 7

Thanks for the tip. I actually was able to resolve the the issue replacing LIBREF LOOKUP with SASHELP.GEOEXM. I will try it using LIBNAME and see if it works as well.

Reeza
Super User

Do you have a library assigned called Lookup as the error indicates?

Did you miss a %include step included in previous codes?

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 300 views
  • 2 likes
  • 3 in conversation