Data;
Input state $ inactivity diabetes @@ ;
Rate=inactivity/diabetes;
datalines;
AL 29.74 11.26
AL 24.74 9.54
AL 33.34 13.52
AL 35.02 11.4
AL 31.94 11.74
AL 32 16.02
AL 35.2 14.02
AL 32.58 12.78
AL 35.18 13.76
AL 32.06 11.62
AL 31.06 11.3
AL 34.02 14.26
AL 33.56 13.16
AL 36.04 12.26
AL 32.48 11.02
AL 29.12 12
AL 30.7 12.5
AL 34.3 14.32
AL 31.72 13
AL 35.78 11.64
AL 31.42 12.66
AL 29.42 11.58
AL 29.46 12.96
AL 33.38 14.3
AL 29.58 11.66
AL 30.26 11.56
AL 35.58 12.44
AL 32.86 12.22
AL 30.68 13
AL 34.8 12.32
AL 32.48 11.66
AL 34.56 16.34
AL 35.36 14.06
AL 29.06 12.62
AL 30.86 11.82
AL 30.48 11.84
AL 28.3 11.34
AL 33.78 11.9
AL 30.62 11.38
AL 33.62 12.8
AL 25.84 10.76
AL 30.66 10.4
AL 33.82 17.92
AL 31.82 15.22
AL 25.22 11.12
AL 34 15.06
AL 36.04 11.72
AL 31.98 11.6
AL 29.64 11.78
AL 31.86 12.74
AL 28.48 13.24
AL 28 10.94
AL 32.88 16.02
AL 32.52 13.86
AL 31.12 14.18
AL 31.94 12.62
AL 33.98 12.76
AL 31.2 11.82
AL 23.54 8.28
AL 31.26 15.16
AL 34.64 12.56
AL 30.46 12.06
AL 28.62 11.26
AL 35.48 12.88
AL 31.8 12.3
AL 32.62 16.32
AL 31.52 10.04
;
ods html close;
ods html;
proc glm;
class state;
model diabetes=state;
means state/lsd bon sidak tukey snk duncan scheffe lines;
Run; The code used above was what was entered into the SAS program, with the hopes that AL and AZ would serve as my two main classes that would be measured. I assumed this due to putting similar words into previous versions of this program in the same column and them manifesting as such. However, once my distribution table came out of my results. The following image proved otherwise. As you can see, the system chose random numbers to use as categories/states, which upon review is likely due to it choosing only part of the data entries shown, as shown below. So, my two questions are as follows; 1. How do I make sure what ends up as a class in SAS aside from what is directly labeled in the "input state" section of my code 2. How do I make sure that the program accepts all my data entries and uses them? P.S. I apologize for using a word document in my initial post. I did that previously because I was unfamiliar with how to upload images into my posts.
... View more