*Import JennyWu.xlsx as WORK.fly;
/* Import the Excel file treeave.xls as Soil */
proc import out=fly
datafile="W:\courses\stat706\JennyWu.xlsx"
replace;
run;
ods graphics on;
proc glm data=fly plots=all;
class chemical day group;
model response=chemical day group;
lsmeans chemical day/pdiff; 
lsmeans day; *Day is a block, but I'm interested in whether there is a trend here;
run;
ods graphics;