Hi Team,   I am looking for same output from HASH join as i have from proc sql. Kindly help.   DATA A; input Name $1. Salary Age; Cards; A 200 20 B 300 30 C 400 40 D 500 50 E 600 60 F 700 70 ; Run; DATA B; input Name $1. Salary Grade$2.; Cards; A 200 AA G 800 GG H 900 HH I 1000 II F 700 FF ; Run; Proc print; run; proc sql; create table AB_SQL as select A.*,B.Grade from A left join B on A.Name=B.Name; quit; ... View more

Hi Team,   I need to delete the duplicate IDs with certain conditions from following dataset.   Data R; input Id sal flag; cards; 1 100 1 1 100 0 2 200 0 2 200 1 3 300 0 4 400 0 4 500 0 ; Run;   1. ID should be unique 2. If flag has '1' / '0' on same ID then need to keep the row with '1' 3. If flag has only '0' on ID then need to keep that row 4. If flag has multiple '0' with respect to same ID then need to keep any one or SAL is different then any   The output could be :  1 100 1 2 200 1 3 300 0 4 400 0   Looking for kind support.   Regards, Uma Shanker Saini ... View more

Hi Team, I have a table which contains 11 variable (ID, Prod1--Prod10). I am getting desired output by following query but i need to make a DI job for the same, Kindly assist which transformation to use and how ( User written transformation is not allowed).   I tried with join + subqery but i was not able to make that, if this one is the correct way, it would be greatful if i could have step by step for that or any pdf link or video link.   Proc sql; Select * from (Select distinct(ID), Product1 from table1 Union Select distinct(ID), Product1 from table1 Union Select distinct(ID), Product2 from table1 Union Select distinct(ID), Product3 from table1 Union Select distinct(ID), Product4 from table1 Union Select distinct(ID), Product5 from table1 Union Select distinct(ID), Product6 from table1 Union Select distinct(ID), Product7 from table1 Union Select distinct(ID), Product8 from table1 Union Select distinct(ID), Product9 from table1 Union Select distinct(ID), Product10 from table1 )R; quit;   Regards, Uma Shanker Saini ... View more