PROC SQL OPTIONS?

DPraba79 — Thu, 19 Nov 2009 03:52:40 GMT

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

Re: PROC SQL OPTIONS?

LinusH — Thu, 19 Nov 2009 08:46:57 GMT

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

topic PROC SQL OPTIONS? in SAS Procedures

PROC SQL OPTIONS?

Re: PROC SQL OPTIONS?