Dear Friends, I'm trying to write a sample SAS program which suppose to extract data from Excel file @ my Desktop and write the data into my "Work.Age" table in SAS. But I am getting the error as "ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\Dantu\Desktop\SASDATA\/Age.xlsx.". It shows in the log one prefix extra "/" forward slash before "Age.xlsx" which is my input excel. But in the actual code there is no such extra forward slash. Requesting to help me out in this issue. Program ==> PROC IMPORT DATAFILE="C:\Users\Dantu\Desktop\SASDATA\Age.xlsx" out=work.Age DBMS=XLSX REPLACE; SHEET="AgeTab"; GETNAMES=YES; RUN; Error Log ==> 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 PROC IMPORT DATAFILE="C:\Users\Dantu\Desktop\SASDATA\Age.xlsx" 63 out=work.Age 64 DBMS=XLSX 65 REPLACE; 66 SHEET="AgeTab"; 67 GETNAMES=YES; 68 RUN; ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\Dantu\Desktop\SASDATA\/Age.xlsx. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 69 70 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 83
... View more