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
| aa | 1 |
| bb | 1 |
| cc | 1 |
| dd | 1 |
| ee | 1 |
| ff | 2 |
| gg | 2 |
| hh | 2 |
| ii | 2 |
| jj | 2 |
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;
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.