PROC SQL OPTIONS?

[DPraba79]

Hi,

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?

Thanks in Advance,
Praba

[LinusH]

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