topic Re: XLSX file can not be created// why $$ was added to the name in SAS Programming

XLSX file can not be created// why $$ was added to the name

Bal23 — Wed, 23 Mar 2016 17:53:41 GMT

proc export data = payaverage
outfile = "c:\paycal"
dbms = XLSX replace;
sheet = "1.2";
run;

There was an error message below.

Error creating temporary file for XLSX file -> c:\\paycal.$$1 . It is either not an Excel
spreadsheet or it is damaged. Error code=80001019
Requested Output File is Invalid
ERROR: Export unsuccessful. See SAS Log for details.

My question is, why it automatically add $$! to the name of excel file? I checked the folder and did find the file with this strange name. However, it cannot be opened.

ANy suggestions why this happened? I want to create an excel file.

Re: XLSX file can not be created// why $$ was added to the name

Tim_SAS — Wed, 23 Mar 2016 17:57:38 GMT

Does this help?

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Wed, 23 Mar 2016 17:58:37 GMT

It's probably how it's marking a temporary file. Have you tried adding the extension in your code?

I don't think the 1.2 sheet name should cause issues, but I would also try removing it if the errors persist.

proc export data = payaverage
outfile = "c:\paycal.xlsx"
dbms = XLSX replace;
sheet = "1.2";
run;

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Wed, 23 Mar 2016 18:13:09 GMT

I did add xlsx. the same error message appeared

then I reomve 1.2 sheet name, it is same

maybe because recently I changed the template? I want to have 56,789 in steadd of 56789. I want the percentage rate be 7.8% instead of 7.833%. Otherwise, I do not know why suddenly this error message appeared

any other advice?

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Wed, 23 Mar 2016 18:17:48 GMT

Your file already exists and you're trying to add to it? What version of SAS do you have? XLSX didn't support adding to files until recently.

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Wed, 23 Mar 2016 18:22:25 GMT

sas 9.4

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Thu, 24 Mar 2016 13:55:15 GMT

Anyone can help with this problem?

Those codes prevously worked but now they could not.

error mesage below:

Error creating temporary file for XLSX file -> c:\TABLES.$$1 .

It is either not an Excel spreadsheet or it is damaged. Error code=80001019

Requested Output File is Invalid

But it still works when I use PDF option to the same destination. But I do need excel files so that I can add more.

Writing ODS PDF output to DISK destination

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Thu, 24 Mar 2016 14:23:29 GMT

Is this a new excel file that you're creating?

Does it work in a different location? With a different dataset? with a different name?

Have you ever been able to create excel files and now it's not working?

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Thu, 24 Mar 2016 14:33:50 GMT

I tried a new excel file. It does not work. I tried to save to different locations, none works.

I also tried my previous code, with different locations. None works now. But they worked and saved to the same drive previously. Yes I have been able to create excel files and able to add more sheets so that I can add table 2,3,4, to an existing table.

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Thu, 24 Mar 2016 14:35:38 GMT

So what's changed? Has your excel version or SAS version changed?

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Thu, 24 Mar 2016 14:38:34 GMT

I did not change my sas. Our SAS is removed installed. So I do not know the detail.

regarding My excel file, I changed the template, as I mentioned, so that the number can be written as 123,456 instead of 123456

that is the only thing I changed

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Thu, 24 Mar 2016 18:17:39 GMT

proc export data = payaverage

outfile = "c:\paycal.xls"

DBMS=EXCEL REPLACE;

SHEET="1.1";

run;

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

Can anybody help to give advice?

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Thu, 24 Mar 2016 18:33:43 GMT

Post the results from the following:

proc setinit;run;

proc product_status;run;

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Thu, 24 Mar 2016 18:36:15 GMT

You mention changing a template so this means you're writing to an existing file. But you've specified the replace option, does that make sense for what you're doing?

Beyond this, you should probably talk to your tech support or SAS tech support, I don't think there's much further we can help you with here.

Re: XLSX file can not be created// why $$ was added to the name

Bal23 — Fri, 25 Mar 2016 14:12:34 GMT

what do you mean by that

Re: XLSX file can not be created// why $$ was added to the name

Reeza — Fri, 25 Mar 2016 16:44:40 GMT

@Bal23 wrote:

what do you mean by that

Since you haven't quoted the post, we have no idea of which response your replying to.

Re: XLSX file can not be created// why $$ was added to the name

sjiawei — Fri, 18 May 2018 04:42:19 GMT

maybe you cann`t access the [C:\paycal.xlsx]. Right click the file → property→security. Check the user that used to run the sas pg. If it is not exist, add it. so you can fix the problem.

file permission have changed when you copy the file.

Re: XLSX file can not be created// why $$ was added to the name

preston1 — Wed, 06 Feb 2019 15:23:27 GMT

I had the same issue then realized someone else had changed the name of the path directory where I was trying to place the EXCEL files. Make sure you have access to write wherever SAS is trying to write.