topic Re: Delete LASR Table with Special Character in SAS Programming

Delete LASR Table with Special Character

Albert0 — Thu, 16 Nov 2017 06:29:51 GMT

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

Re: Delete LASR Table with Special Character

saspert — Tue, 06 Mar 2018 17:31:37 GMT

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

Re: Delete LASR Table with Special Character

ChrisNZ — Wed, 07 Mar 2018 00:59:48 GMT

What does the housekeeping program do?

Re: Delete LASR Table with Special Character

Albert0 — Wed, 07 Mar 2018 01:07:09 GMT

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