I am looking for some advice about interactions in SAS.    I am running a MIXED linear model with categorical and continuous variables. I am trying to determine if there is a quadratic relationship in the variable labeled cat. Normally I would put cat*cat or cat|cat to try to get an interaction. But when I run that code, my output still doesn't have an interaction as one of my type 3 tests of fixed effects. Is there a different symbol to try? Does anyone have any advice? My log shows no error messages, but there must be something wrong.    The code looks like this:   proc mixed data= allstock6 ;  class robotnr yr2 week2 cat; model Meal= ages week1 cat week2 cat*cat/ddfm=SATTERTH s;  random pony week2(yr2) yr2; repeated /type=ar(1) subject=pony; lsmeans cat/diffs; run;   Any help would be greatly appreciated! ... View more

Hey. I am using SAS 9.4 and trying to add the numbers between to set values to a data set (column D). The goal is to have the data count down so that 11 Jan 17 would be day 6, 12 January 17 would be day 5 etc.    My current data set looks like this:    Animal     Date               TIME                 Avgbout               Daysb4challenge 1           11Jan17             AM                      12                                6 1           12Jan17             AM                       12 1           13Jan17            AM                        12  1           14Jan17            AM                         12 1           15Jan17            AM                         16 1           16Jan17            AM                         14                               1 2           11Jan17              AM                       13                                5 2          12Jan17            AM                           14 2           13Jan17            AM                           13 2           14Jan17           AM                             15 2           15Jan17            AM                           12 2           16Jan17           AM                             11                           0   We tried to use COUNT to count between the numbers to no avail. I imagine that we can use a PROC EXPAND, but I ave only used a lag and lead statement before. Any help would be greatly appreciated!   ... View more