Hi all,
Can any one tell me that , How we can change table Alias name Inside Join transformation.
Exp. I have a table called name "USERS".
In join transformation , when we give the join condition then it should change ALias Name.
like : RD_USERS.
can any body help me quickly....?
Thanks in advance...
Hi @Riteshdell,
If this is DI Studio, open the Join by double-clicking it and have a look at the Navigate tree in the side bar. If you click on a table in the From yhou will see the propereties of that table underneath. There is an Alias property available. That will cause your SQL to go like "FROM Table1 T1" ...
Hope this helps,
- Jan.
proc sql;
select rd_users.* from users as rd_users;
quit;
@Kurt_Bremser- I need in this in transformation setting, some where in Join transformation. it is there.
But right now, I am unable to find it.
PS: I dont need through coding.
When defining a query in Enterprise Guide, right-clicking on the source table lets one select "Options", and there one can change the alias.
Hi @Riteshdell,
If this is DI Studio, open the Join by double-clicking it and have a look at the Navigate tree in the side bar. If you click on a table in the From yhou will see the propereties of that table underneath. There is an Alias property available. That will cause your SQL to go like "FROM Table1 T1" ...
Hope this helps,
- Jan.
@jklaverstijn-- Thanks for your correct help.. I got it....
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.