*Copyright @ www.mycsg.in;

Export males dataset from work library to an excel workbook named males.xlsx

proc export data=males
    outfile="&root2._males.xlsx" replace;
run;

Export females dataset from work library to an excel workbook named females.xlsx

proc export data=females
    outfile="&root2._females.xlsx" replace;
run;

Export class dataset from work library to an excel workbook named class.xlsx and the sheet name should be students

proc export data=class
    outfile="&root2._class.xlsx" replace;
    sheet="Students";
run;

Export the datasets males, females, class into separate sheets of a workbook named mydata.xlsx

proc export data=males
    outfile="&root2._mydata.xlsx" replace;
run;
 
proc export data=females
    outfile="&root2._mydata.xlsx" replace;
run;
 
proc export data=class
    outfile="&root2._mydata.xlsx" replace;
run;

Export males dataset to a workbook named males_label.xlsx, instead of variable names display variable labels

data males;
    set males;
    label name="Name of the student"
    height="Height (Inches)"
    weight="Weight (Pounds)"
    ;
run;
 
 
proc export data=males
    outfile="&root2._males_label.xlsx" replace label;
    sheet="Males - With variable labels";
run;
 
proc export data=males
    outfile="&root2._males_label.xlsx" replace;
    sheet="Males - With variable Names";
run;