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

Frequent Contributor
Posts: 80

# 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: 113

Super User
Posts: 7,844

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

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,190

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

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;``````
Discussion stats
• 3 replies
• 134 views
• 1 like
• 4 in conversation