Help using Base SAS procedures

PROC SQL OPTIONS?

Reply
Contributor
Posts: 34

PROC SQL OPTIONS?

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
Super User
Posts: 5,256

Re: PROC SQL OPTIONS?

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 163 views
  • 0 likes
  • 2 in conversation