How to split a data set equally

[venkatard]

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

[RichardinOz]

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

[venkatard]

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'

[RichardinOz]

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

[venkatard]

May be i was not clear.

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

[Xianhua_zeng]

%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

[Keith]

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;

[PGStats]

Or simpler:

%let groups=10;

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

PG

[Keith]

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

[naiksairam22]

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