topic Re: How to: export to excel file in SAS Programming

How to: export to excel file

Ngo99 — Mon, 16 May 2022 06:28:30 GMT

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.

Re: How to: export to excel file

andreas_lds — Mon, 16 May 2022 08:50:29 GMT

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

Re: How to: export to excel file

TrevorH — Sun, 17 Dec 2023 19:51:33 GMT

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.

Re: How to: export to excel file

SASKiwi — Sun, 17 Dec 2023 20:00:01 GMT

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.

Re: How to: export to excel file

TrevorH — Sun, 17 Dec 2023 23:12:51 GMT

Ok that makes sense.

Re: How to: export to excel file

TrevorH — Sun, 17 Dec 2023 23:13:58 GMT

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

Re: How to: export to excel file

SASKiwi — Sun, 17 Dec 2023 23:35:05 GMT

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.

Re: How to: export to excel file

TrevorH — Mon, 18 Dec 2023 03:08:21 GMT

Yup got it thx