Proc Means By Dummies

[finans_sas]

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

[PGStats · Accepted solution]

Means with ways 1;

proc means data=myData noprint;

var return;

class onemonth secondmonth;

ways 1;

output out=myMeans mean=;

run;

PG

[Ksharp]

Or using TYPES statement.

proc means data=myData noprint;
var return;
class onemonth secondmonth;
types onemonth secondmonth;
output out=myMeans mean=;
run;

Ksharp

[finans_sas]

Thank you so much for your help. Both suggestions work great.