BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
HitmonTran
Pyrite | Level 9

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

aa1
bb1
cc1
dd1
ee1
ff2
gg2
hh2
ii2
jj2

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
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;

View solution in original post

1 REPLY 1
novinosrin
Tourmaline | Level 20
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;
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 908 views
  • 0 likes
  • 2 in conversation