Unable to Import from OneDrive into SAS EG

[alicezwang96]

I have my OneDrive synced to the OneDrive folder on my computer. I am trying to import from this folder into SAS EG using this code:

proc import out = table
datafile='C:\Users\johnsmith\ABC Company\ABC Company SubFolder\Import File.csv'
dbms=csv
replace;
guessingrows=20000;
run;

I'm receiving the below error:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
ERROR: Physical file does not exist.

The file is definitely in the location. I imported the file into EG using import wizard then copied that file path into the query to be sure. Any suggestions on how to fix this?

[ballardw]

I suggest using Windows Explorer to navigate to that folder and click in the top part where the folder name is. That should show a path that you can copy and paste into SAS where the path is used.

I do this about 10 time a week, if not more.

I suspect your path is missing something as mine includes "One Drive" in the path, but your organization may vary.

[Tom]

That first NOTE message has nothing to do with whether or not SAS can find the file you are trying to import.

There is a BUG in proc import that generates that message.  It is trying (for no discernable reason) to update an SLIST object in a CATALOG in the SASUSER library.  When you do not have write access to the SASUSER library or the PARMS catalog in the SASUSER library then it spits out that silly message, but it does not have any impact on the actual importing of the file.

Note that is is perfectly NORMAL to not have write access to the SASUSER library.   It will happen whenever you happen to be running two instances of SAS at the same time. And you can force it by using the RSASUSER option on startup of SAS, which is extremely useful as then when you do run more than one SAS session at once they both will use your SASUSER.PROFILE settings.

If the message bothers you then use some other method of reading the text file into a SAS dataset.  If you write your own data step you will have more control.  Or use some other tool to examine the file and guess how to read it.  Such as:

https://github.com/sasutils/macros/blob/master/csv2ds.sas

[ChrisHemedinger]

The Import Data task in EG will transfer the CSV file to your SAS session. But if your SAS session is remote, it cannot see your local C: drive to read the CSV with PROC IMPORT.

Use the Copy Files task to first copy the CSV file to a folder on your SAS session, then use PROC IMPORT to reference that location.