proc means in macro

Occasional Contributor
Posts: 6

proc means in macro

I am new to SAS programming, especially the macro programming aspect. I am having trouble creating a macro for this data set. Basically I want to get the means for x1 or x2 for females and y1 or y2 for males. 


data xx;
input gender $ x1 x2 y1 y2;
male . . 14 15
male . . 17 18
female 21 22 . .
female 25 26 . .


Any suggestions or input would be great

Super User
Super User
Posts: 8,129

Re: proc means in macro

Posted in reply to IsoscelesKramer

Not sure what macro has to do wth the question.

proc summary data=xx nway ;
  class gender ;
  var x1 x2 y1 y2 ;
  output out=want mean= ;

This will produce a dataset with two rows, one for males and one for females with the means of X1 , X2 , Y1 and Y2.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation