Dear SAS Community Members,
I would like to compute the mean of "returns" variable below and its t-statistics by dummy variables. In other words, I want to find out what the average return is when onemonth=1 and onemonth=2. I actually have 8 dummies and I am aware of the fact that I can create 8 subsets of my data for each dummy. I was just wondering if there was a more efficient way to accomplish this task.
month return signal onemonth secondmonth
1 0.25 down 0 0
2 0.41 up 1 0
3 -0.27 down 0 1
4 -0.37 up 1 0
5 -0.24 up 0 1
6 0.24 up 0 0
Thanks
Means with ways 1;
proc means data=myData noprint;
var return;
class onemonth secondmonth;
ways 1;
output out=myMeans mean=;
run;
PG
Means with ways 1;
proc means data=myData noprint;
var return;
class onemonth secondmonth;
ways 1;
output out=myMeans mean=;
run;
PG
Or using TYPES statement.
proc means data=myData noprint; var return; class onemonth secondmonth; types onemonth secondmonth; output out=myMeans mean=; run;
Ksharp
Thank you so much for your help. Both suggestions work great.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.