Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using proc glm with excel data set

Status
Not open for further replies.

maonome

Instructor
Apr 15, 2009
2
CA
Hello,

I have a data set imported from excel that I cannot figure out how to make it do an ANOVA on.

vertically I have different sites (sampled in different months) and for each site there are 6 numbers in different cells horizontally. what I want to do is compare sites by using the 6 numbers (they will make an average/stdev etc). (if different will follow up with Tukey ettc)

below is the code I have, but I don't know what y should be. I have tried labeling each of the 6 columns and listing each of them where y is. or do I have to enter the data manually into SAS?

proc glm;
where month = 'August';
class Site;
Model y = Site;
run;

thanks for the help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top