I want to get sum of a variable wgt for each date and firm id. I wrote the following simple code, but didn't get what I want. Can someone have a look and let me know what's wrong.
proc sort data=have; by date firm; run;
data want; set have; by date firm; summ=sum(wgt); run;
Thanks.
data want;
set have;
by date firm;
retain summ;
summ=sum(summ,wgt);
if last.firm then
do;
output;
call missing(summ);
end;
run;
Alternatively,
data want;
set have;
by date firm;
retain summ;
if first.firm then summ=wgt;
else summ+wgt;
run;
Thanks,
Jagadish
Even less verbose:
data want;
set have;
by date firm;
sum+wgt+(-first.firm*sum);
run;
Haikuo
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.