Day function if you need to convert it, Day format if you want to summarize by day across various months and want to avoid having to create a new variable.
... View more
The NWAY option on the PROC MEANS statement should ensure that only the highest level is reported in the output dataset, but the TYPES statement is another way to do that.
... View more
data datasetC ;
set dataseta;
if _n_=1 then do;
if 0 then set datasetb;
dcl hash H (dataset:'datasetb') ;
h.definekey ("site") ;
h.definedone () ;
end;
matched=h.check()=0;
run;
... View more
data have;
input Person $ boat $ Fish ;
cards;
John A 2
David A 1
Sam B 4
Mike C 3
Carley C 5
Mark C 1
;
proc sql;
create table want as
select *,sum(fish) as fish_boat
from have
group by boat;
quit;
... View more