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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.