topic unable to export the excel file in SAS Programming

unable to export the excel file

sg_kr — Wed, 03 Jul 2019 10:41:47 GMT

Hi,

when i run the below export proc, im unable to export it.

proc export data=FSB_2
outfile="&Dir./fsb_&month..xlsx"
dbms=xlsx replace;
sheet="fSb";
run;

Error:

ERROR: Temporary file for XLSX file can not be created -> O:\Financial Information
Management\Financial Information\BI_Reporting\SAS\Retail Reporting\EPG\2019-05\fsb_05.$$1. Make
sure the path name is correct and that you have write permission.

can anyone please help me on this.

thanks.

Re: unable to export the excel file

PaigeMiller — Wed, 03 Jul 2019 10:45:42 GMT

@sg_kr wrote:

Make sure the path name is correct and that you have write permission.

Seems like a relatively clear error message to me. Did you check to see if the file name and folder name is correct and that the folder actually exists, and that you have write permission to that folder?

Re: unable to export the excel file

Kurt_Bremser — Wed, 03 Jul 2019 10:46:42 GMT

It's already there:

Make sure the path name is correct and that you have write permission.

This is exactly what you need to check. Keep in mind that the SAS process running on a specific server may not have access to the same network shares you have mounted on your desktop.

Re: unable to export the excel file

sg_kr — Wed, 03 Jul 2019 10:49:48 GMT

but when i run the run the same thing in VDI Machine its working.

when i run on remote machine , its not.

can i know how can i get rid of this.

thanks.

Re: unable to export the excel file

sg_kr — Wed, 03 Jul 2019 10:55:39 GMT

yes, i have.
its working when i run this on VDI machine but not remote machine.

Re: unable to export the excel file

PaigeMiller — Wed, 03 Jul 2019 11:06:35 GMT

From @Kurt_Bremser earlier in this thread

Keep in mind that the SAS process running on a specific server may not have access to the same network shares you have mounted on your desktop.

Your remote machine can't write to the same locations. Beyond that, no one here can say because we don't know your computer systems.

Re: unable to export the excel file

Kurt_Bremser — Wed, 03 Jul 2019 11:06:38 GMT

@sg_kr wrote:

but when i run the run the same thing in VDI Machine its working.

when i run on remote machine , its not.

can i know how can i get rid of this.

thanks.

Then the path is available on that machine, but not on your (other) SAS server. Check that, or have it checked by your system admins.

By the way, what is VDI?

Re: unable to export the excel file

sg_kr — Wed, 03 Jul 2019 11:09:02 GMT

i have already mapped the network drive to the machine, i checked it.

VDI:virtual Desktop Infrastructure.

Re: unable to export the excel file

Kurt_Bremser — Wed, 03 Jul 2019 11:16:50 GMT

@sg_kr wrote:
i have already mapped the network drive to the machine, i checked it.

SAS tells you different. And in disputes like this, SAS is right in about 100% of cases. The path is either not there, or the SAS process lacks the necessary permissions. Ask your system admins, they know your IT infrastructure.

Re: unable to export the excel file

PaigeMiller — Wed, 03 Jul 2019 12:04:53 GMT

When SAS and the user disagree, I believe SAS. You can't write to that location from your remote machine.

Now, as @Kurt_Bremser and I have pointed out, this is not a SAS issue any more, and there's no one in this (or any other) SAS forum who can solve this for you. The solution is to discuss this with your IT department and have them figure out why your remote machine cannot write to this location (or perhaps talk to a colleague in your department who might know).