In my head I had it right ... I meant data _null_;
set have end=end_of_have;
length value $10 freq 8;
if _n_=1 then do;
declare hash h (ordered:'a');
h.definekey('value');
h.definedata('value','freq');
h.definedone();
end;
array month {12} f1-f12;
do m=1 to 12;
value=month{m};
if h.find()^=0 then freq=1;
else freq=freq+1;
h.replace();
end;
if end_of_have then h.output(dataset:'want');
run;
... View more