DATA Step, Macro, Functions and more

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

Reply
Frequent Contributor
Posts: 93

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

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?

Frequent Contributor
Posts: 118

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

Posted in reply to rajeshalwayswel

Any attempts you had done?  Post your code.

Super User
Super User
Posts: 8,260

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

Posted in reply to rajeshalwayswel

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;
PROC Star
Posts: 1,400

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

Posted in reply to rajeshalwayswel

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;
Ask a Question
Discussion stats
  • 3 replies
  • 156 views
  • 1 like
  • 4 in conversation