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 15male . . 17 18female 21 22 . .female 25 26 . .;run;
Any suggestions or input would be great
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.
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!