topic Re: how to generate sequence number per every 5 obs? in SAS Programming

how to generate sequence number per every 5 obs?

HitmonTran — Tue, 11 Jan 2022 20:16:45 GMT

HI,

I need to generate a sequence number per every 5 obs.

below is the data with variable "var". I want variable "seq" . THank you

data :

var seq

novinosrin — Tue, 11 Jan 2022 20:29:48 GMT

data have;
input var $;
cards;
aa	1
bb	1
cc	1
dd	1
ee	1
ff	2
gg	2
hh	2
ii	2
jj	2
;

data want;
  set have;
  if mod(_n_,5)=1 then seq+1;
run;