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

[cnn96]

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

[CarmineVerrell · Accepted solution]

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