topic Re: Calculating missing rows in SAS Programming

Calculating missing rows

Nrjn7 — Tue, 10 Aug 2021 18:11:15 GMT

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?

Re: Calculating missing rows

Reeza — Tue, 10 Aug 2021 18:13:47 GMT

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;

Re: Calculating missing rows

Nrjn7 — Tue, 10 Aug 2021 18:27:10 GMT

@Reeza Thank you.

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

Re: Calculating missing rows

PaigeMiller — Tue, 10 Aug 2021 18:30:35 GMT

/* 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;

Re: Calculating missing rows

Reeza — Tue, 10 Aug 2021 19:08:09 GMT

Add SURVEY into the TABLES statement.

table id*Tables / out=ID_COUNTS;