topic Re: How to split data into training data and test data? in SAS Data Science

How to split data into training data and test data?

ainlayray — Thu, 08 Mar 2018 07:32:48 GMT

Im using SAS 9.4

So, I have a car data. I want to split data into training data and test data based on a variable "model year".

I want model year which is even to be training data and model year which is odd to be test data.

I tried the following code:

proc import out=work.car5
datafile= "C:\desktop\Auto1.csv" dbms=csv;
getnames=yes; datarow=2;
run;

data train test;
set year;
b=mod(year,2);
if b=0
then output train;
else output test;
run;

but i got some error message. it did not work. How to solve this problem?? Thanks in advance!!

Re: How to split data into training data and test data?

andreas_lds — Thu, 08 Mar 2018 07:50:34 GMT

@ainlayray wrote:

...

but i got some error message. it did not work. How to solve this problem?? Thanks in advance!!

This is normal logic: if you get an error message something did not work. So please post the log that we can see that message.

Re: How to split data into training data and test data?

ainlayray — Thu, 08 Mar 2018 08:01:47 GMT

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TRAIN may be incomplete. When this step was stopped there were 0
observations and 2 variables.
WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 0
observations and 2 variables.

oh i see. im new here. This is the error message after the code. It created 2 new sets but 0 observations...

Re: How to split data into training data and test data?

andreas_lds — Thu, 08 Mar 2018 08:04:44 GMT

Sorry, my request was misleading: please post the complete log including all steps that are executed.

Re: How to split data into training data and test data?

ainlayray — Thu, 08 Mar 2018 19:13:18 GMT

thanks!

okay, I will post in that format in my next posts. I will post the complete code and log.

And I just solved my problem. In my command: "set year" , it refers to year data, not year variable.

so, I changed that to "set car5" which refers to my data. Then it worked... It is like many beginners' mistake...

Thanks anyways!!