Apologies datanull, I forgot the response metric excel file, attached here. Class isn't a variable in the model, it is only used in the creation of those new variables. Dhana, thanks for the reply- as mentioned above, I am going to bold this so future readers do not miss it the colon does not work in the model statement unless I am using it incorrectly :smileysilly: If you have it working in a model statement in proc glmselect, please let me know. Array might work, I will try this but I am afraid it is going to consider the whole array as one variable, and my whole point of using the macro was to break up the variables. Perhaps I am wrong in how SAS will interpret it though.
... View more