topic Re: How to assign group wise sequence for particular range in SAS Programming

How to assign group wise sequence for particular range

thanikondharish — Tue, 11 Jun 2019 07:11:53 GMT

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
;

Re: How to assign group wise sequence for particular range

PeterClemmensen — Tue, 11 Jun 2019 07:15:53 GMT

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
;

Re: How to assign group wise sequence for particular range

thanikondharish — Tue, 11 Jun 2019 07:21:16 GMT

More than 50 value is .(missing)

Re: How to assign group wise sequence for particular range

PeterClemmensen — Tue, 11 Jun 2019 07:23:17 GMT

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;

Re: How to assign group wise sequence for particular range

thanikondharish — Tue, 11 Jun 2019 07:29:15 GMT

Yes it's working