I have data with several variables including store_id, location, and product_cat.  Store_Id ranges from 1-8, location ranges from 1-9 (representing outside, entrance etc.), and product_cat ranges from 1-8 (representing candy, cereal, etc).  I need the mean number of "displays/counts" per store by location and product_cat.  I'm unsure how to transform this data to get the correct information.  ... View more

I have scored data from 3 time points, the scores range from 0-5.    If the data is normal, can I run this? proc glimmix data=test; class sex(ref='1') education(ref='1') race_ethn(ref='1') age; model score=time sex education race_ethn age hhsize/s dist=GAUSSIAN LINK=CUMLOGIT or; random time; run;   Do I include time in the class statement?  Also, it is correct to include time in the random statement? To account for nature of the data, dependent, do I need to include: Store=ID. repeated subject=store / corr=ind corrw;   If the data is not normal, can I run this? proc glimmix data=test; class sex(ref='1') education(ref='1') race_ethn(ref='1') age; model score=time sex education race_ethn age hhsize/s dist=multinomial LINK=CUMLOGIT or; random time; run;   Should the distribution actually be poisson since it's count data (i.e. scored data)? ... View more