topic Re: How to give for every ten observation as 0 for remaining as 1? in SAS Programming

How to give for every ten observation as 0 for remaining as 1?

rajeshalwayswel — Mon, 11 Dec 2017 00:14:08 GMT

I"m having a dataset contains 1000 observations I need to present for every 10 observations as 0 and for remaing all are as 1?

ShiroAmada — Mon, 11 Dec 2017 02:27:35 GMT

Any attempts you had done? Post your code.

Tom — Mon, 11 Dec 2017 03:50:21 GMT

So you want to a new variable that is 0 for every tenth observation?

data want;
  set have;
  newgroup = not 0=mod(_n_,10);
run;

PeterClemmensen — Mon, 11 Dec 2017 07:26:25 GMT

I'm not sure I get this, but do something like this

data have;
input x y z;
do i=1 to 1000; output; end;
datalines;
1 2 3
;

data want;
	set have;
	newVar=1;
	if mod(_n_,10)=1 then newVar=0;
run;