BookmarkSubscribeRSS Feed
DPraba79
Calcite | Level 5
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
1 REPLY 1
LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 743 views
  • 0 likes
  • 2 in conversation