Hello, I am looking to create a list of tables a program creates (create table) and uses (from or join). My goal is to drop tables when possible but I don't want to drop a table in Program 1 if it's used in Program 2 of the same project. I have tried the following code to list work table but I also want to find permanent tables the program is creating and using. proc sql ;
create table work_tables as
select * from dictionary.tables
where libname = 'WORK'
order by memname ;
quit ; From this code, I'd like to see the tables it created and used such as; work.Agreement_Data work.Base_Data work.Agreement_Prep PROC SQL;
CREATE TABLE WORK.Agreement_Data as
Select
t1.*,
t2.*
FROM WORK.Base_Data t1
LEFT JOIN WORK.Agreement_Prep t2
ON t1.Local_Agreement_Identifier = t2.Local_Agreement_Identifier
AND t1.Audit_Request_Identifier = t2.Audit_Request_Identifier
/*AND MISSING(Detail.Audit_Request_Identifier)*/
; you're time is appreciated.
... View more