topic Re: How to split a data set equally in SAS Programming

How to split a data set equally

venkatard — Mon, 08 Apr 2013 06:50:49 GMT

I have a data set of 8600 records and i need to split the data set equally and create a flag for each group

Re: How to split a data set equally

RichardinOz — Mon, 08 Apr 2013 07:42:15 GMT

Do you need 2 different tables?

Data one two ;

set have ;

if mod (_N_, 2) = 1 then

do ;

flag = 'ONE' ;

output one ;

end ;

else

do ;

flag = 'TWO' ;

output two ;

end ;

Run ;

Richard

Re: How to split a data set equally

venkatard — Mon, 08 Apr 2013 07:58:09 GMT

No i only want the output in a single dataset with flags which are dividing the data.

For example if i have 8600 record i will have 860 in one flag='One'

Re: How to split a data set equally

RichardinOz — Mon, 08 Apr 2013 08:01:31 GMT

860 is not half of 8600.

You should be able to work out what to do from my code, mostly by leaving out lines of code.

Richard

Re: How to split a data set equally

venkatard — Mon, 08 Apr 2013 08:06:57 GMT

May be i was not clear.

I want to split the data of 8600 as 860 for each dataset *10 datasets.

Re: How to split a data set equally

Xianhua_zeng — Mon, 08 Apr 2013 08:23:41 GMT

%macro splitdata;

%do i=1 %to 8600 %by 860;

data want_&i.;

set have(firstobs=&i obs=%eval(&i+859));

flag="&i-%eval(&i+859)";

run;

%end;

%mend splitdata;

%splitdata

Re: How to split a data set equally

Keith — Mon, 08 Apr 2013 08:30:32 GMT

A simple method if you don't want a random split. This also avoids hard coding the number of observations.

%let groups=10;

data want;

set have nobs=nobs;

flag=ceil(_n_/(nobs/&groups.));

run;

Re: How to split a data set equally

PGStats — Mon, 08 Apr 2013 12:22:52 GMT

Or simpler:

%let groups=10;

data want;
set have;
flag=mod(_n_-1, &groups.);
run;

Re: How to split a data set equally

Keith — Mon, 08 Apr 2013 12:41:07 GMT

Indeed, very good. You could always make it even simpler and take out the -1.....

Re: How to split a data set equally

naiksairam22 — Fri, 04 Oct 2019 19:41:15 GMT

Dear Friends,

I have 40lac data in sas need separate data in two data set equally kindly suggest ho can I do it.

Thanks
Sai