topic Re: how to do a match sequence in SAS in SAS Programming

how to do a match sequence in SAS

MABRINCH — Fri, 29 Jan 2021 06:00:57 GMT

what is the SAS equivalent to SPSS's matchsequence (a sequential count of matching case in each group)?

I want to number cases with same ID by a date(ascending) and if same date then by a stage(descending).

Data want:

ID	date	stage	matchseq
1	01-10-2016	4	1
1	04-06-2019	4	2
2	30-09-2018	4	1
2	30-09-2018	2	2
3	01-10-2016	1	1
3	21-10-2016	3	2
3	04-06-2019	1	3

Re: how to do a match sequence in SAS

PeterClemmensen — Fri, 29 Jan 2021 06:12:42 GMT

So matchseq is the variable you want right?

Re: how to do a match sequence in SAS

PeterClemmensen — Fri, 29 Jan 2021 06:49:31 GMT

I think this is what you want

data have;
input ID date :ddmmyy10. stage matchseq;
format date ddmmyy10.;
datalines;
1 01-10-2016 4 1
1 04-06-2019 4 2
2 30-09-2018 4 1
2 30-09-2018 2 2
3 01-10-2016 1 1
3 21-10-2016 3 2
3 04-06-2019 1 3
;

data want;
   set have;
   by ID;
   if first.ID then match_seq = 0;
   match_seq + 1;
run;

Re: how to do a match sequence in SAS

MABRINCH — Fri, 29 Jan 2021 08:12:44 GMT

"matchseq" is the variable I want.

Re: how to do a match sequence in SAS

PeterClemmensen — Fri, 29 Jan 2021 08:13:45 GMT

Ok have you tried the code above?