topic Creating a street address map using LIBREF LOOKUP in New SAS User

Creating a street address map using LIBREF LOOKUP

Ihsan-Mahdi — Wed, 31 May 2023 18:39:04 GMT

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 🙂

Re: Creating a street address map using LIBREF LOOKUP

ballardw — Wed, 31 May 2023 19:02:02 GMT

@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.

Re: Creating a street address map using LIBREF LOOKUP

Reeza — Wed, 31 May 2023 19:04:21 GMT

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

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

Re: Creating a street address map using LIBREF LOOKUP

Ihsan-Mahdi — Wed, 31 May 2023 19:18:44 GMT

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.