I have a dataset with variables date, firm id, dummy and asset. What I want to achieve is for each date, each firm id, calculate a weight for each observation according to asset when dummy=0, and do the same for dummy=1. A simple example is as below
date firm id dummy asset weight
1 A 0 50 50/(50+50)=0.5
1 A 0 50 50/(50+50)=0.5
1 A 1 20 20/(20+80)=0.2
1 A 1 80 80/(20+80)=0.8
I want to get the weight shown above. How can I use proc sql to get the results? Or other ways?
Thanks.
Hi,
Please try the below code
data have;
input date firm_id$ dummy asset;
cards;
1 A 0 50
1 A 0 50
1 A 1 20
1 A 1 80
;
proc sql;
create table want as select date,firm_id,dummy,asset,asset/sum(asset) as weight from have
group by date,firm_id,dummy;
quit;
Thanks,
Jagadish
Hi,
Please try the below code
data have;
input date firm_id$ dummy asset;
cards;
1 A 0 50
1 A 0 50
1 A 1 20
1 A 1 80
;
proc sql;
create table want as select date,firm_id,dummy,asset,asset/sum(asset) as weight from have
group by date,firm_id,dummy;
quit;
Thanks,
Jagadish
Thanks. I am going to try it, but it seems to be correct.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.