I'm working in SAS Visual Analytics version 4.0.  I would like to partition data in Build Models, but the corresponding menu in project settings is grayed out (see screenshot below).   Additionally, I would like to partition data in a specific way using my blocking variable "block".  Based on the options shown above, there does not appear to be a way to do this.  However, it does seem that the "Explore and Visualize" module has this capability, however, my blocking variable is not listed as an option for some reason (see screenshot below).  Available are a number of categorical variables, and for some reason a single continuous variable.  Note that the variable "Block" is visible in the data pane as a categorical variable with 4 levels.   Ideally, my data partitions would set training, validation, and test partitions to 50, 25, and 25%, respectively, using any of blocks 1, 2, 3, of 4. Thanks for reading! ... View more

I am analyzing data from a factorial experiment using PROC GLIMMIX in SAS.  In the model, "Trt_Amend_App" is a categorical variable that is one of the experimental treatments and "ID_S" is one of two locations. The model results indicate that there is a significant interaction between Trt_Amend_App and ID_S such that Trt_Amend_App is significant at one location, but not the other. I would like to conduct a post-hoc test to determine which levels of Trt_Amend_App are different from each other, corrected for multiple comparisons using the Tukey adjustment, but only for the significant location "Site 2". How might I code that? I've included the code for my model below.  The commented line under the first LSMEANS statement can be thought of a pseudocode indication of what I want to do (it doesn't work 🙂).   proc glimmix data=df_y3_t3 plots=studentpanel; class ID_S Block Trt_Amend_App Trt_CC; model Response_Var = Trt_Amend_App | Trt_CC | ID_S ID_S(Block); lsmeans ID_S * Trt_Amend_App / slice=ID_S plot=meanplot(sliceby=Trt_Amend_App join); /*lsmeans Trt_Amend_App / diff adjust=tukey where(ID_S='Site 2');*/ run; I understand that the WHERE statement can be used to achieve the desired test in a separate procedure, but I'm hoping for a more streamlined solution.  Thanks for reading. ... View more

I'm stumped as to why the concatenate function "cat" is not working for me.   data df; set df; Trt_Unique = cats(Trt_Amend, "_", Trt_App, "_", Trt_CC); run;   I don't know what to make of the error indicating that argument 5 is "invalid".  The string "no_CC" concatenates just fine to other strings in the variable.  Notice how "Ctrl-Fert_NA_CC" concatenates just fine, but there is an error for "Ctrl-Fert_NA_no_CC".  Printing the data shows that these values are omitted by the operation.     The issue doesn't seem to be that the character limit is exceeded.  Using a length statement prior to the set statement causes the variable to not be created for some odd reason, without any errors to indicate why.  Any ideas regarding this issue would be appreciated.  Thanks for reading. ... View more