Solved
Contributor
Posts: 57

# Proc Means By Dummies

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

Accepted Solutions
Solution
‎09-20-2012 04:27 PM
Posts: 5,541

## Re: Proc Means By Dummies

Means with ways 1;

proc means data=myData noprint;

var return;

class onemonth secondmonth;

ways 1;

output out=myMeans mean=;

run;

PG

PG

All Replies
Solution
‎09-20-2012 04:27 PM
Posts: 5,541

## Re: Proc Means By Dummies

Means with ways 1;

proc means data=myData noprint;

var return;

class onemonth secondmonth;

ways 1;

output out=myMeans mean=;

run;

PG

PG
Super User
Posts: 10,787

## Re: Proc Means By Dummies

Or using TYPES statement.

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

Ksharp

Contributor
Posts: 57

## Re: Proc Means By Dummies

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

🔒 This topic is solved and locked.

Discussion stats
• 3 replies
• 477 views
• 3 likes
• 3 in conversation