BookmarkSubscribeRSS Feed
ACraven1
Calcite | Level 5

Downloaded the StreetLookupData.zip files to run some PROC GEOCODE and get valuable latitude/longitude data BUT - when I run through the installation program for the data

/*--- Edit macro variables to specify locations on your system. */

%let PATHIN=C:\Users\ACRAVEN1\Documents\StreetLookupData_94-2018; /* Directory with files from the zip archive */

%let PATHOUT=C:\Users\ACRAVEN1\Desktop\Geocode; /* Location to write geocoding data sets */

 

I get this error:

ERROR: Unable to get SAS code. Could not find a part of the path

'C:\Users\ACRAVEN1\AppData\Local\Temp\1\Temp1_StreetLookupData_94-2018.zip\ImportCSVfiles.sas'.

 

These are folders that do exist (I copied their paths in Windows explorer) and the PATHIN folder does contain the .csv files that make up the data.  Anyone have any insight into why this won't work?

 

Thanks!

4 REPLIES 4
SASKiwi
PROC Star

It's the folder location of the SAS program - ImportCSVfiles.sas - that causes the error. Does 'C:\Users\ACRAVEN1\AppData\Local\Temp\1\Temp1_StreetLookupData_94-2018.zip' exist?

 

Also I hope your SAS session is running locally on your PC and not a remote SAS server as that would also explain the error.

ACraven1
Calcite | Level 5

I think the issue with that error ended up being the location of the program I was running. I moved it to the folder for PathIN and it got past that error but now the LOOKUP library doesn't seem to exist and is preventing other files from generating. 

SASKiwi
PROC Star

Post the complete log of that step then.

Reeza
Super User

Did you unzip the files? I would highly recommend moving them out of the download folder as well. 

I've run those programs so I do know they work. 

 

 

 

 


SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 735 views
  • 0 likes
  • 3 in conversation