How to: export to excel file

[Ngo99]

Hi, I am trying to export my sas code into an excel file. However, when I typed this code this is the message I am receiving. 

code: 

proc export data=WORK.IMPORT
 outfile="C:/User/user/Documents/export/resultingdataset.xlsx"
dbms=xlsx;
run;

result:

ERROR: Temporary file for XLSX file can not be created -> /folders/myfolders/export//resultingdataset.$$1. Make sure the path name

is correct and that you have write permission.

[andreas_lds]

This problem has been discussed so many times .... the server your sas session is running on can't access your local drives.

[TrevorH]

I am able to export with the SAS Export Wizard but I get this error when I try to do it with proc export. I have copied and pasted the path from the wizard.

[SASKiwi]

What is the path from the SAS Export Wizard? If it is a path on your PC then the remote SAS server running PROC EXPORT will not be able access it. Talk to your SAS administrator about setting up a folder share that will work for both methods.  

[TrevorH]

Ok that makes sense.

[TrevorH]

Btw, the path is to a location on the LAN.

[SASKiwi]

Same applies for LAN folders. You'll need to get an IT administrator to set up a SAS server folder share with the LAN folder.

[TrevorH]

Yup got it thx