From My understanding, I used hai.kuo HAVE dataset, data dummy ; do var='A','B','C','D','E'; do hours=1 to 4; do year=2011; output; end; end; end; run; proc sql; create table temp as select a.*,b.month,b.day,b.hour from dummy a left join have b on a.year=b.year and a.hours=b.hour and a.var=b.var order by a.hours,a.var; quit; data want; set temp; array v(3) month hour day; do i=1 to dim(v); if v(i)=. then v(i)=0; end; drop i; run; proc print; run; might be some one will give elegant answer Thanks Sam
... View more