topic Help me with a data procedure in SAS Programming

Help me with a data procedure

SeanZ — Sun, 20 Oct 2013 06:53:44 GMT

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.

Re: Help me with a data procedure

Patrick — Sun, 20 Oct 2013 08:02:50 GMT

data want;

set have;

by date firm;

retain summ;

summ=sum(summ,wgt);

if last.firm then

do;

output;

call missing(summ);

end;

run;

Re: Help me with a data procedure

Jagadishkatam — Sun, 20 Oct 2013 11:05:10 GMT

Alternatively,

data want;

set have;

by date firm;

retain summ;

if first.firm then summ=wgt;

else summ+wgt;

run;

Thanks,

Jagadish

Re: Help me with a data procedure

Haikuo — Sun, 20 Oct 2013 15:21:34 GMT

Even less verbose:

data want;

set have;

by date firm;

sum+wgt+(-first.firm*sum);

run;

Haikuo