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

[Bal23]

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.

[Tim_SAS]

Does this help?

[Reeza]

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;

[Bal23]

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?

[Reeza]

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.

[Bal23]

sas 9.4

[Bal23]

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

[Reeza]

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?

[Bal23]

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.

[Reeza]

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

[Bal23]

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

[Bal23]

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?

[Reeza]

Post the results from the following:

proc setinit;run;

proc product_status;run;

[Bal23]

what do you mean by that

[Reeza]

---

@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.