I want to peform left outer join in hash with following code (so as to reproduce the result of left join in Proc Sql).     data a; input key d1 d2 d3; datalines; 1 1 1 1 1 2 2 2 1 3 3 3 2 1 1 1 2 2 2 2 4 1 1 1 4 1 1 1 5 5 5 5 ; data b; input key d4 d5 d6 other; datalines; 1 1 1 1 0 2 2 2 2 0 3 3 3 3 0 4 4 4 4 0 ; data test(drop=rc); if 0 then set A; if _n_=1 then do; dcl hash h(dataset:'A',multidata:'yes'); h.definekey('key'); h.definedata('d1','d2','d3'); h.definedone(); end; set B (keep=key d4 d5 d6); rc=h.find(); do while(rc=0); output; rc=h.find_next(); end; run; ... View more

I am trying to merge these two data sets a and b.  I want  this to be like this (missing id1 replaced by nonmissing id2 and keep their corresponding values as one observation and rest matching observations)   want 1 0  1 2 0  1 3 0  1 4 0  1 5 0  1 data a; infile cards ; input id1 x ; cards; 1 0 2 0 3 0 . 0 5 0 ; run; data b; infile cards; input id2 y; cards; 1 1 2 1 3 1 4 1 5 1 ; run; proc sql _method; create table want as select coalesce(id1,id2) as id, a.x, b.y from a as a left join b as b on a.id1=b.id2; run;       ... View more

How to retrieve the particular element of hash object , let's say 10th element from hash object of sashelp.class? data work.test; if 0 then set sashelp.class; if _n_=1 then do; dcl hash h(dataset:'sashelp.class',ordered:'A',multidata:'yes'); dcl hiter hi('h'); h.definekey('Name'); h.definedata(all:'y'); h.definedone(); end; /*rc=h.output(dataset:'work.out');*/ rc=hi.first(); rc1=hi.next(); put rc; put rc1; run; ... View more