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

[Reeza]

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.

[sjiawei]

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.

[preston1]

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.