BookmarkSubscribeRSS Feed
Albert0
Quartz | Level 8
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
3 REPLIES 3
saspert
Pyrite | Level 9

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

ChrisNZ
Tourmaline | Level 20

What does the housekeeping program do?

Albert0
Quartz | Level 8

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1458 views
  • 0 likes
  • 3 in conversation