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
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
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.