Help using Base SAS procedures

Proc Means By Dummies

Accepted Solution Solved
Reply
Contributor
Posts: 57
Accepted Solution

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
Respected Advisor
Posts: 4,926

Re: Proc Means By Dummies

Posted in reply to finans_sas

Means with ways 1;

proc means data=myData noprint;

var return;

class onemonth secondmonth;

ways 1;

output out=myMeans mean=;

run;

PG

PG

View solution in original post


All Replies
Solution
‎09-20-2012 04:27 PM
Respected Advisor
Posts: 4,926

Re: Proc Means By Dummies

Posted in reply to finans_sas

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,035

Re: Proc Means By Dummies

Or using TYPES statement. Smiley Happy

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

Posted in reply to finans_sas

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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