PROC IMPORT....multiple sheets

[sivastat08]

hi ,i'm trying to import multiple sheets in sas eg below is the code i used,

%macro pim(sheet);
proc import out= AR
datafile = 'C:\Users\sivakumar.sivaraj\Desktop\Data_Import.xlsx'
dbms = Excel;
sheet = "&sheet";
getnames = yes;
run;
%mend pim;
%pim(DumpKey);
%pim(UniqueProcedureID);
%pim(ReportDateIST);

after running this code its showing below error. can any one please help me to fix this.

ERROR: Unable to open file C:\Users\sivakumar.sivaraj\Desktop\Data_Import.xlsx. It does not exist or it is already opened
exclusively by another user, or you need permission to view its data.

thanks,

siva

[Kurt_Bremser · Accepted solution]

In EG, do you use "Local" as your server, or another workspace server definition?

If other than Local, your workspace server may run on a remote computer and therefore can't "see" your C: drive.

If Local, it may be that the file is kept open by the last program that used it (probably Excel itself). Make sure that all Excel instances are closed and try again.

[sivastat08]

Thanks for the quick replay Kurt,the sas is working on workspace server and i'm importing file from local desktop.i have checked agin its showing the same error

"ERROR: Unable to open file C:\Users\sivakumar.sivaraj\Desktop\Data_Import.xlsx. It does not exist or it is already opened
exclusively by another user, or you need permission to view its data."

is it stating any access level restriction..kindly hhelp me resolve this..

[Kurt_Bremser]

Right-click on the server in your server list, select Properties.

You will see the hostname of the physical machine where your workspace server is running.

If it is not the name of your desktop, you have a remote installation. In this case,

- copy the file(s) to that server, preferably your home directory there. Use WinSCP or similar.

or

- if your desktop and the server have access to a common network resource (or the server shares a resource you could use from your desktop), copy the file(s) there and use them from there. Ask the network/server admin for path names.

[sivastat08]

thanks for detailed replay Kurt.