proc means in macro

IsoscelesKramer — Mon, 17 Apr 2017 22:07:50 GMT

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;
datalines;
male . . 14 15
male . . 17 18
female 21 22 . .
female 25 26 . .
;run;

Any suggestions or input would be great

Re: proc means in macro

Tom — Mon, 17 Apr 2017 22:21:15 GMT

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= ;
run;

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

topic proc means in macro in SAS Programming

proc means in macro

Re: proc means in macro