topic Re: Street Lookup Data Issues in SAS Programming

Street Lookup Data Issues

ACraven1 — Mon, 05 Oct 2020 23:25:41 GMT

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!

Re: Street Lookup Data Issues

SASKiwi — Mon, 05 Oct 2020 23:51:25 GMT

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.

Re: Street Lookup Data Issues

ACraven1 — Tue, 06 Oct 2020 00:22:42 GMT

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.

Re: Street Lookup Data Issues

SASKiwi — Tue, 06 Oct 2020 00:46:27 GMT

Post the complete log of that step then.

Re: Street Lookup Data Issues

Reeza — Tue, 06 Oct 2020 00:56:11 GMT

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.