What is the easiest way to take around 80% and data and test it against the rest 20%? I'm using regression and want to find the best model and RMSE and R-squared and AIC etc. are very close. And by easiest I mean as for someone new to SAS.
Or Am I should I just pick the lowest RMSE or the best model from the SELECTION option? I have over 80,000 observations and the numbers are really close
a simple way to generate a validation data set and a training data set with 20/80 split
data rand;
set have;
random=ranuni(0);
run;
data train_plus_validate;
set rand;
original_y=y;
if rand>0.8 then y=.;
run;
proc reg data=train_plus_validate;
model y=x1 x2 x3;
output out=predicteds p=predicted;
run;
By setting y to missing in the validation data set, these observations are not used in creating the regression model, but you do get predicted values for each of them (that's what PROC REG does if the y is missing); you can then see how close the predicted values are to variable ORIGINAL_Y.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: