04-17-2017 06:07 PM
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.
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
04-17-2017 06:21 PM
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.