Hi,
I'm trying to import an Excel file into SAS University Edition running on Oracle VirtualBox on a Windows 10 PC. I've read and tried quite a few posts and solutions, but haven't found the problem. I've shared myfolder in Windows and set it up in VM. I can see the folders and files in the Files and Folders tab in SAS Studio. I have no trouble accessing other files in the shared folder for training exercises. I've tried placing the input file in both "myfolders" and in a sub directory. It must be some rookie mistake.
From the Error message, it appears that I have a problem with the shared folder. Looking for assistance.
Thanks in advance for your assistance.
Below is my log:
There is potentially more than one issue you have to deal with.
The first one:
You're using a relative path in your Proc Import syntax - datafile='folders/my....' . I guess that's a typo and you just will have to add the beginning slash or you could also use something like: datafile="&path/foodsecuritydatafile2017.xlsx"
The second one:
WARNING: Library FOOD does not exist.
That kind of indicates that the path as such doesn't exist. Does library ORION work when you try to access data from it?
There is potentially more than one issue you have to deal with.
The first one:
You're using a relative path in your Proc Import syntax - datafile='folders/my....' . I guess that's a typo and you just will have to add the beginning slash or you could also use something like: datafile="&path/foodsecuritydatafile2017.xlsx"
The second one:
WARNING: Library FOOD does not exist.
That kind of indicates that the path as such doesn't exist. Does library ORION work when you try to access data from it?
Thanks to @Patrick and @Reeza: I didn't "see" the leading "/". Then, as Patrick suggested, I had screwed up the shared files settings in my efforts to fix things. Resetting shared files and adding the back-slash solved the problem.
This is my first time using the community. I am impressed and grateful with the prompt and accurate responses. Feeling very encouraged.
Thank you both!
You forgot the / in front of folders in the datafile option.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.