I need a proc sql options that expands table alies to table name in select statement. For example i have a code like,
PROC SQL FEEDBACK _METHOD;
SELECT A.EMP_ID FROM EMP_TABLE AS A;
QUIT;
i want to some proc sql option that expands in sas log like below,
SELECT EMP_TABLE.EMP_ID FROM EMP_TABLE AS A
Could you please provide me the sql option that expands table alies as table name in column present in SELECT statement?
If this isn't a pass-thru SQL, I'm not aware of an option that could do this.
Do you need this for documentation purposes?
If you embed your query within a macro, you could build a logic for parsing the original table name in the log.
/Linus