topic Re: The deleted table will automatically be recovery by "$" table in SAS Programming

The deleted table will automatically be recovery by "$" table

GeorgeSAS — Sun, 30 Apr 2017 02:11:53 GMT

Hello All,

When I trying to update .xlsx file woth libname excel engine,

libname mylib Excel 'C:\temp\aaaaaa.xlsx';

I am trying to Delete the table :
proc sql
drop table mylib.'myData$'n;
quit;

But It will automaticaly recovery the deleted tables by the table end with a "$", also I can't delete the talbes with "$"

what to do??

Thanks!

Re: The deleted table will automatically be recovery by "$" table

Shmuel — Sun, 30 Apr 2017 03:27:53 GMT

Define FILENAME refering the excel file that need to be deleted, then

use FDELETE function to delete the file.

filename todel 'C:\temp\aaaaaa.xlsx';

data _null_;

rc = fdelete(todel);

run;

Old $ files, try to delete by OS command.

Re: The deleted table will automatically be recovery by "$" table

Reeza — Sun, 30 Apr 2017 05:41:38 GMT

Is myData a sheet or named range?

Re: The deleted table will automatically be recovery by "$" table

GeorgeSAS — Sun, 30 Apr 2017 17:23:11 GMT

a sheet name.
after deleted and create new one. the old one still there but the new one will change name followed by an extra '1'

That is: if I delete sheet1 and create new sheet1, the old sheet1 will be still there, but my new sheet1 will become sheet11

Re: The deleted table will automatically be recovery by "$" table

Tom — Sun, 30 Apr 2017 21:33:39 GMT

Why do you have three different threads for the same topic?

If you cannot update your version of SAS to something more modern then perhaps you can instead ask Excel to remove the sheet for you.

You should also check your settings in Excel. Perhaps there is some setting in Excel that is causing the sheets to not be permanently deleted?

Did you try closing the workbook between when you delete the old sheet and when you try to add it back?

Re: The deleted table will automatically be recovery by "$" table

GeorgeSAS — Sun, 30 Apr 2017 22:06:17 GMT

Thank you Tom.

I create new topic because I just find new problem need to be focused.excuse me for the confuse.

At same time I tried to modify Excel.I can't find the solution so far and I am still keeping on trying.

I tried close them before modify them for sure. in each times.