Delete LASR Table with Special Character

Reply
Contributor
Posts: 40

Delete LASR Table with Special Character

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
Super Contributor
Posts: 284

Re: Delete LASR Table with Special Character

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

PROC Star
Posts: 2,319

Re: Delete LASR Table with Special Character

What does the housekeeping program do?

Contributor
Posts: 40

Re: Delete LASR Table with Special Character

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

Ask a Question
Discussion stats
  • 3 replies
  • 481 views
  • 0 likes
  • 3 in conversation