topic Proc Means By Dummies in SAS Procedures

Proc Means By Dummies

finans_sas — Thu, 20 Sep 2012 20:01:08 GMT

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

Re: Proc Means By Dummies

PGStats — Thu, 20 Sep 2012 20:27:53 GMT

Means with ways 1;

proc means data=myData noprint;

var return;

class onemonth secondmonth;

ways 1;

output out=myMeans mean=;

run;

Re: Proc Means By Dummies

Ksharp — Fri, 21 Sep 2012 01:53:59 GMT

Or using TYPES statement.

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

Ksharp

Re: Proc Means By Dummies

finans_sas — Fri, 21 Sep 2012 10:16:07 GMT

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