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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.