topic Re: How to change table Alias name in Join tranformation in SAS Data Management

How to change table Alias name in Join tranformation

Riteshdell — Mon, 06 Jun 2016 12:38:11 GMT

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...

Re: How to change table Alias name in Join tranformation

Kurt_Bremser — Mon, 06 Jun 2016 12:41:13 GMT

proc sql;
select rd_users.* from users as rd_users;
quit;

Re: How to change table Alias name in Join tranformation

Riteshdell — Mon, 06 Jun 2016 13:21:00 GMT

@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.

Re: How to change table Alias name in Join tranformation

Kurt_Bremser — Mon, 06 Jun 2016 13:26:56 GMT

When defining a query in Enterprise Guide, right-clicking on the source table lets one select "Options", and there one can change the alias.

Re: How to change table Alias name in Join tranformation

jklaverstijn — Mon, 06 Jun 2016 15:03:03 GMT

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.

Re: How to change table Alias name in Join tranformation

Riteshdell — Tue, 07 Jun 2016 07:32:04 GMT

@jklaverstijn-- Thanks for your correct help.. I got it....