topic Facing error in using proc import in SAS Programming

Facing error in using proc import

Ananyayadav — Thu, 16 Aug 2018 07:19:18 GMT

I am trying to run IMPORT in one of the excel file but i am facing some error. please have a look:

proc import datafile='/folders/myfolders/Datasets/cars_excel.xlsx'
dbms=xlsx
out=test.car_dummy;
getnames=no;
run;

and the error appearing in log is window is:

ERROR: Physical file does not exist, /folders/myfolders/Datasets//cars_excel.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.04 seconds

cpu time 0.06 seconds

i have already located excel file i.e., cars_excel.xlsx in above path.can anyone clarify where i am wrong?

Re: Facing error in using proc import

Kurt_Bremser — Thu, 16 Aug 2018 07:32:18 GMT

If you set up the SAS UE virtual machine correctly, the name of the shared folder is /folders/myfolder (no trailing s) from within the VM.

Re: Facing error in using proc import

ballardw — Thu, 16 Aug 2018 14:40:59 GMT

Also your path in the error does not match the path in shown code.

With errors it is best to copy the submitted code and the error message from the log and then paste into a code box here using the forum's {I} icon. The message windows will sometimes reformat the text moving some of the indicators SAS places for some error messages to a different location. Copying both from log removes questions about whether "code" shown was what was actually submitted.