DATA Step, Macro, Functions and more

how to split 506 data into two different data set

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

how to split 506 data into two different data set

I need to Split the data into two parts, and use the first half of 253 data points for building the model, and the second half of 253 data points for testing. The data point are here:

https://archive.ics.uci.edu/ml/machine-learning-databases/housing/housing.data

 

So I ran the data in SAS and got the data point. I tried the following code to split them but no success:

 

Data trainingData;
Set housing;
do i=1 to 253;
output;
end;
run;

 

I am new to SAS so I am not sure what is wrong there. Any help would be appreciated.

 

Thank you,

 

 

 


Accepted Solutions
Solution
‎11-20-2017 06:07 PM
Super User
Posts: 22,874

Re: how to split 506 data into two different data set

Posted in reply to Sara73737
Data trainingData testData;
Set housing;

if _n_ <= 253 then output trainingData;
else output testData;

run;

Sara73737 wrote:

I need to Split the data into two parts, and use the first half of 253 data points for building the model, and the second half of 253 data points for testing. The data point are here:

https://archive.ics.uci.edu/ml/machine-learning-databases/housing/housing.data

 

So I ran the data in SAS and got the data point. I tried the following code to split them but no success:

 

Data trainingData;
Set housing;
do i=1 to 253;
output;
end;
run;

 

I am new to SAS so I am not sure what is wrong there. Any help would be appreciated.

 

Thank you,

 

 

 


 

View solution in original post


All Replies
Solution
‎11-20-2017 06:07 PM
Super User
Posts: 22,874

Re: how to split 506 data into two different data set

Posted in reply to Sara73737
Data trainingData testData;
Set housing;

if _n_ <= 253 then output trainingData;
else output testData;

run;

Sara73737 wrote:

I need to Split the data into two parts, and use the first half of 253 data points for building the model, and the second half of 253 data points for testing. The data point are here:

https://archive.ics.uci.edu/ml/machine-learning-databases/housing/housing.data

 

So I ran the data in SAS and got the data point. I tried the following code to split them but no success:

 

Data trainingData;
Set housing;
do i=1 to 253;
output;
end;
run;

 

I am new to SAS so I am not sure what is wrong there. Any help would be appreciated.

 

Thank you,

 

 

 


 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 2 in conversation