05-07-2017 04:08 PM
I would like to us proc genmode with repeated measures. but with a good sample size (1,000,000 id )?
How does it work? When I put subject=Customer_id, it doesn't seem to work as I guess because my sample size is big?
proc genmod data=work.modelling_dataset;
model target=no_trans week;
repeated subject = id / type=exch corrw; run; quit;
05-08-2017 10:25 AM
05-09-2017 08:09 AM
One thing I could think is appending the TEST data at the end of TRAIN data
( target variable should be missing in your TEST data).
proc append base=MODELLIND_DATASET data=TEST force;run;
proc hpmixed data=MODELLIND_DATASET;
And use OUTPUT to score the TEST data.
And hope you can get the predicted value in output dataset.