topic Assign incremental category based on a pre-specified sort by a discrete variable which value repeat in SAS Procedures

Assign incremental category based on a pre-specified sort by a discrete variable which value repeat

Karolus — Tue, 15 Nov 2022 20:04:38 GMT

Hi everyone,

I have the following scenario:

The raw data has a seqoccur to indicate the order in which it happened and cannot be changed. The type variable indicates what happened among to only possibilities.

data rawdata;
input seqoccur 1-2 type $ 3-13;
cards;
1 CONTINUOUS
2 CONTINUOUS
3 BROKEN
4 BROKEN
5 BROKEN
6 BROKEN
7 CONTINUOUS
8 CONTINUOUS
9 CONTINUOUS
10 CONTINUOUS
11 CONTINUOUS
12 BROKEN
13 CONTINUOUS
14 BROKEN
15 BROKEN
;
run;

To this, in the variable I call 'grouptype' I need to assign a value incrementally as below, i.e. repeating within the first type of occurrence and incrementing by the next occurrence and the number doesn't change until the next occurrence. I've tried the usual sort/retain/first.variable techniques but none I know gives the result as below in "grouptype". Any suggestions? many thanks!

data want;
input seqoccur 1-2 type $ 3-13 grouptype 14-15;
cards;
1 CONTINUOUS 1
2 CONTINUOUS 1
3 BROKEN 2
4 BROKEN 2
5 BROKEN 2
6 BROKEN 2
7 CONTINUOUS 3
8 CONTINUOUS 3
9 CONTINUOUS 3
10 CONTINUOUS 3
11 CONTINUOUS 3
12 BROKEN 4
13 CONTINUOUS 5
14 BROKEN 6
15 BROKEN 6
;
run;

Re: Assign incremental category based on a pre-specified sort by a discrete variable which value rep

Karolus — Tue, 15 Nov 2022 20:06:47 GMT

p.s. apologies for the typos , I meant "among two only possibilities"

Re: Assign incremental category based on a pre-specified sort by a discrete variable which value rep

PeterClemmensen — Tue, 15 Nov 2022 20:09:22 GMT

data rawdata;
input seqoccur 1-2 type $ 3-13;
cards;
1 CONTINUOUS
2 CONTINUOUS
3 BROKEN
4 BROKEN
5 BROKEN
6 BROKEN
7 CONTINUOUS
8 CONTINUOUS
9 CONTINUOUS
10 CONTINUOUS
11 CONTINUOUS
12 BROKEN
13 CONTINUOUS
14 BROKEN
15 BROKEN
;
run;

data want;
   set rawdata;
   by type notsorted;
   if first.type then grouptype + 1;
run;

Result:

seqoccur  type        grouptype
1         CONTINUOUS  1
2         CONTINUOUS  1
3         BROKEN      2
4         BROKEN      2
5         BROKEN      2
6         BROKEN      2
7         CONTINUOUS  3
8         CONTINUOUS  3
9         CONTINUOUS  3
10        CONTINUOUS  3
11        CONTINUOUS  3
12        BROKEN      4
13        CONTINUOUS  5
14        BROKEN      6
15        BROKEN      6

Re: Assign incremental category based on a pre-specified sort by a discrete variable which value rep

Karolus — Tue, 15 Nov 2022 21:23:12 GMT

oh my, of course, a very forgotten option, 'by notsorted'. A millions thanks!!