topic Re: sas, proc export, version number, delete xlsx in New SAS User

sas, proc export, version number, delete xlsx

user112a2 — Fri, 26 Apr 2019 15:43:48 GMT

I have noticed that when I add new fields, I have to keep changing the version number on the proc export excel file. Is there SAS code I can run before this to delete that xlsx on the unix server? That would greatly help, therefore I would not need to keep on changing the version number in the file. Thanks for your help.

Removed

Re: sas, proc export, version number, delete xlsx

Reeza — Thu, 08 Nov 2018 21:35:02 GMT

Have you tried the FDELETE() function?
https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0h945u5r0cv6yn1u6qs35hiqt9t.htm&docsetVersion=9.4&locale=en

Re: sas, proc export, version number, delete xlsx

LaurieF — Fri, 09 Nov 2018 01:28:50 GMT

I would have thought that replace should be that you would need. What error message do you get when you run the code where the file already exists?

If replace doesn't work in this case, maybe some hacking of my Excel backup delete macro might help?