How to assign group wise sequence for particular range

[thanikondharish]

Data ex1;
Input number ;
Cards;
3
9
22
34
49
3
33
50
12
23
34
48
;
If we take range 50 how to create sequence number 50 group wise like see below

Number seq

3. 1
9. 1
22. 1
34. 1
49. 1
3. 2
33. 2
50. 2
12. 3
23. 3
34. 3
48. 3
;

[PeterClemmensen]

What if a value was over 50? What if your data looks like this?

Data ex1;
Input number ;
Cards;
3
9
22
34
49
3
33
50
51
12
23
34
48
;

[thanikondharish]

More than 50 value is .(missing)

[PeterClemmensen]

See if this works for you 🙂

data ex2(drop=lagnum);
    set ex1;
    if _N_=1 then seq=1;
    lagnum=lag1(number);
    if lagnum gt number then seq+1;
run;

[thanikondharish]

Yes it's working