Delete LASR Table with Special Character

[Albert0]

Hi All,

I would like to ask if there is a code that could delete lasr table that has special characters into it or table names that started with a special character or number?

Sample: (2) Table Name
2015_Report

I have a housekeep program that deletes tables that are no longer in use but I have an error when these tables are in que. I don't have control in writing the tablenames since different departments are dumping their tables in the server.


Thanks

-Albert0

[saspert]

Try moving your post to the correct community. this is general programming stuff. 

[ChrisNZ]

What does the housekeeping program do?

[Albert0]

Hi ChrisNZ,

Basically, the housekeep program that I made is to delete all LASR tables that are not used anymore and backup all the LASR table by creating a SAS datasets counterpart of the table.

BTW, I've found a solution to call and delete the table in my sas code by adding string literal n to the table name or macro. E.g. Summary Table 1 => 'Summary Table 1'n.

Albert0