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!!
@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.
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...
Sorry, my request was misleading: please post the complete log including all steps that are executed.
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!!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.