Calculating missing rows

[Nrjn7]

ID	Survey	Survey_repeat	Day
1	A	1	1
1	A	2	2
2	A	1	1
2	A	2	2
2	A	3	3
2	A	4	4
2	A	5	5
3	A	1	1
3	A	2	2

So, every participant completes a survey 5 times, one each day. I want to calculate how many are missing.

In this case, ID 1 and 3 have 3 surveys missing. How do I tally this?

[Reeza · Accepted solution]

Use PROC FREQ to count the number of days and save that to a dataset. Then 5 - the number to see how many are missing.

proc freq data=have;
table id / out=ID_COUNTS;
run;

data want;
set ID_COUNTS;
NMISS = 5 - FREQ;
run;

[Nrjn7]

@Reeza  Thank you.

How do I approach the problem if there are multiple surveys.

[Reeza]

Add SURVEY into the TABLES statement.

table id*Tables / out=ID_COUNTS;

[PaigeMiller]

/* UNTESTED CODE */
proc summary data=have nway;
    class id;
    var survey_repeat;
    output out=_max_ max=survey_repeat_max;
run;
data want;
     set _max_;
     number missing = 5 - survey_repeat_max;
run;

If there can be multiple surveys, then use

class id survey;