LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 18 Aug 2009 08:12:43 -0700
Reply-To:     ash007 <ramsamyashley@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         ash007 <ramsamyashley@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Left Join with Hash
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

hello sas-users,

i would like to obtain the same datasets (output) for the 2 methods below, i want please to have the same dataset of the slq method.

data table_bidon1; input x1 x2 x3 x4 x5 $; cards; 1 5 5 1161 abéen 2 5 5 1161 abéen 3 6 3 1336 alméc 4 1 5 1499 aniel ; run;

data table_bidon2; input w1 w2 w3 w4 w5 $; cards; 3 6 3 1336 alméc 4 1 5 1499 aniel 5 6 3 1336 alméc 6 1 5 1499 aniel 5 6 3 1336 alméc 6 1 5 1499 aniel 3 6 3 1336 alméc 4 1 5 1499 aniel 3 6 3 1336 alméc 4 1 5 1499 aniel 3 6 3 1336 alméc 4 1 5 1499 aniel 3 6 3 1336 alméc 4 1 5 1499 aniel

; run;

proc sql; create table jointure_bidon_sql as select a.x1,b.w2 from table_bidon1 as a left join table_bidon2 as b on a.x1 = b.w1 ; quit;

data jointure_bidon_hash (keep = x1 w2);

if _n_ = 1 then do ; if 0 then set table_bidon1 table_bidon2; dcl hash h (dataset: "table_bidon2"); h.definekey ("w1"); h.definedata ("w2"); h.definedone (); end;

set table_bidon1; if h.find (key: x1) ne 0 then call missing (w2); run;


Back to: Top of message | Previous page | Main SAS-L page