How can delete all the rows of patient ids when they appear more than once?

cnn96 — Thu, 02 Feb 2023 13:55:03 GMT

Hello people

i am currently trying to solve a problem, but have not managed so far. i am quite new to programming, so it may also be that the solution is very simple.

I have the following table:

My goal is to have only those on my new list that have only one entry.

Can someone please help me here?

Best thanks in advance

cnn

Re: How can delete all the rows of patient ids when they appear more than once?

CarmineVerrell — Thu, 02 Feb 2023 14:02:34 GMT

The way i would tackle this would be with the datastep.

You would need to first sort the data with a proc sort

proc sort data=test ;

by patientid;

run;

data test2;

set test;

by patientid;

if first.patientid=1 and last.patientid=1;

run;

I would recommend you take the elearning programming 1 course on our website. Its free and you will learn lots of great things to start using SAS. Here is a link SAS Training in the United States -- SAS® Programming 1: Essentials

topic Re: How can delete all the rows of patient ids when they appear more than once? in SAS Procedures

How can delete all the rows of patient ids when they appear more than once?

Re: How can delete all the rows of patient ids when they appear more than once?