https://communities.sas.com/t5/New-SAS-User/My-duplicates-wont-delete/m-p/592700#M15396 <P>I use the code:</P><P>proc sort nodupkey nodup data=finaldata out=unique; by study_id; run; *get count of people in the dataset=153 there are 6 duplicates.</P><P>&nbsp;</P><P>When I do a proc means it still shows the 6 duplicates. there are a lot of variables in my data set and I want to delete certain study_id duplicates.</P><P>&nbsp;</P><P>proc means data=finaldata;<BR />var v_ht_0;<BR />by intervention;<BR />run;&nbsp;</P><P>&nbsp;</P> Mon, 30 Sep 2019 14:35:39 GMT mariamon0 2019-09-30T14:35:39Z https://communities.sas.com/t5/New-SAS-User/My-duplicates-wont-delete/m-p/592700#M15396 <P>I use the code:</P><P>proc sort nodupkey nodup data=finaldata out=unique; by study_id; run; *get count of people in the dataset=153 there are 6 duplicates.</P><P>&nbsp;</P><P>When I do a proc means it still shows the 6 duplicates. there are a lot of variables in my data set and I want to delete certain study_id duplicates.</P><P>&nbsp;</P><P>proc means data=finaldata;<BR />var v_ht_0;<BR />by intervention;<BR />run;&nbsp;</P><P>&nbsp;</P> Mon, 30 Sep 2019 14:35:39 GMT https://communities.sas.com/t5/New-SAS-User/My-duplicates-wont-delete/m-p/592700#M15396 mariamon0 2019-09-30T14:35:39Z https://communities.sas.com/t5/New-SAS-User/My-duplicates-wont-delete/m-p/592701#M15397 <P>You should run your PROC MEANS code on&nbsp;<STRONG>unique</STRONG> (the output data from PROC SORT). Not <STRONG>finaldata</STRONG></P> Mon, 30 Sep 2019 14:37:42 GMT https://communities.sas.com/t5/New-SAS-User/My-duplicates-wont-delete/m-p/592701#M15397 PeterClemmensen 2019-09-30T14:37:42Z