03-08-2016 01:10 PM
03-10-2016 10:43 AM
This is how the code could look, if you wanted a simple GLM model:
*import dataset into SAS; data have; infile 'C:\_localdata\data.csv' dlm="," dsd truncover lrecl=1000; informat var1-var40 best32.; format var1-var40 best32.; input var1-var40; run; *Run model; proc glm data=have; model var1 = var2--var40; run;quit;
03-10-2016 01:09 PM
Your file had 40 variables, it was a demo of how it could be accomplished.
It had no headers so I don't know which is y, which is x etc.
I simply took the first variable as the Y and the remaining as X to demonstrate the GLM procedure.
To develop a final model you might want to use a selection method to subset the variables. PROC GLMSELECT is helpful here.
Please consider my code a sample, not what you should do. You should know what your variables are and how they should be handled.
03-10-2016 01:17 PM
Many thanks for your response I understood you mean.
My bad. Mistakengly I put 55*40 input. It should be 55*20 but I see you mean. The 40 is the sample number. I do have 55 variables so is the following right?
proc glm data=have; model y = var1--var55; run;quit;
I don't now what GLMSLECT is doing at the final stage. I will research for it. Many thanks for your responses.