11-09-2015 04:28 AM
I think this should be an easy fix however i cant figure out a solution. Have tried searching on the forum as well and tried what was suggested however still cant get the desired resolution.
I am trying to add data stored in excel file in my systems D drive.
Please see the code along:
PROC IMPORT DATAFILE="/D:\Shivi\To & Fro Analysis\BookingCombined.xlsx"
Evertime this error throws an error:
"ERROR: Physical file does not exist". Request you to please suggest what is the miss.
11-09-2015 04:33 AM
"/D:\Shivi\To & Fro Analysis\BookingCombined.xlsx"
Is invalid, may just be that there is an extra / at the beginning, try:
"D:\Shivi\To & Fro Analysis\BookingCombined.xlsx"
But make sure that D:\Shivi\To & Fro Analysis
Is a valid path, and is accessible to SAS, and that in that folder there is a file called: BookingCombined.xlsx
If your using University Edition, look on the specific UE forum, as there are many posts about it.
Also, try to avoid typing all in upper case.
11-09-2015 06:13 AM
Ah, you see its useful to post the question in teh right forum them. As you are using University Edition - which is different to the version most of us use, you will need to supply a correct URL to the path, so the D:\ part would be invalid. You can find a lot of these posts by using the search box on the main page. Here for example is a post which explains how to import a file into UE:
You will note that UE needs something like:
and that your file be placed in the area accessible to UE - which doesn't use local network mappings like D:.
11-09-2015 11:02 AM
11-10-2015 12:19 AM
thanks for helping on this one.
While i was watching the step by step instructional video for university edition it also promoted me to follow the same process which you have outlined below.
Apologies if this sounds crazy but i have not worked on unix environment ever so what i understand is that do i need to get in touch with my IT team to have a virtual machine or VM ware installed on my machine & thereafter i can create the required folder structure.
11-10-2015 03:47 AM
University Edition is already installed on a VM. You ned to access the VM and put your file on a folder on that Virtual Machine. Please see the link I posted and the help documentation provided by SAS:
11-10-2015 04:59 AM
Hi RW9 & Reeza,
My sincere apologies and seems like i have done one of the dumbest things in my life. While what i was thinking was a SAS Studio it was SAS OnDemand application hence i was not able to upload data as you were describing.
This triggered me when i was not able to locate the SAS Studio folder on my desktop. All this confusion was because i had always been using SAS 9.2 and 9.3 versions or SAS EGuide or Miner and this seems like all together a different fascia.
Once again apologies and thanks for extending support.