topic Re: Repeating values in SAS Programming

Repeating values

stancemcgraw — Tue, 19 Jan 2021 20:39:59 GMT

Hello,

I have multiple rows of patient data with a repeating ID, but the data contained within each row is different. The patient ID on top is the one I'd like to remove:

data have;

studyid age sex los cause of injury

2048 34 F 3 MVA

2048 33 F 4 MCC

data want;

studyid age sex los cause of injury

2048 33 F 4 MCC

Re: Repeating values

Reeza — Tue, 19 Jan 2021 20:42:11 GMT

Is it always the first one?

data want;
set have;
by studyID;
if first.studyID;
run;

Re: Repeating values

novinosrin — Tue, 19 Jan 2021 20:44:39 GMT

Agree with @Reeza 's solution. I am making the assumption to account for a case where there's just one studyid record

data have;
infile cards truncover;
input (studyid     age    sex     los    causeofinjury) ($);
cards;
2048         34        F        3       MVA
2048         33        F        4       MCC
;

data want;
 set have;
 by studyid;
 if first.studyid and last.studyid or not first.studyid;
run;

Re: Repeating values

Reeza — Tue, 19 Jan 2021 20:50:30 GMT

I think my solution works even if the StudyID has only one record, because that would still be the first record.

Re: Repeating values

novinosrin — Tue, 19 Jan 2021 20:53:35 GMT

Oops @Reeza the OP doesn't want the 1st record. Am i mistaken?

"The patient ID on top is the one I'd like to remove:"

Re: Repeating values

Reeza — Tue, 19 Jan 2021 21:20:08 GMT

You are correct, I read it wrong, it should be last.StudyID not first.StudyID.
If last.studyID would be the equivalent and works for all situations regardless of multiples or a single study ID.

Re: Repeating values

novinosrin — Tue, 19 Jan 2021 21:24:52 GMT

@Reeza Are you assuming all by groups to have only 2 records for last.studyid alone check?

Re: Repeating values

Reeza — Tue, 19 Jan 2021 21:27:56 GMT

I'm assuming that you'd only keep the last record. You're assuming that you only remove the first record. Given the data, I highly suspect it would make sense to only include the last record but only OP can clarify that issue.