How would you delete duplicate observations?

Answer Posted / vijay

There are several ways to do this. However the easliest
code-wise is to use PROC SORT. For example:

PROC SORT DATA=mydata NODUPKEY;
BY variable;
RUN;

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to test the debugging in sas?

900


How substr function works in sas?

928


Where do you use proc means over proc freq?

793


Explain substr function?

827


what is ae onset date n what is RDS

2177


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3378


What is the use of stop statement?

864


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1404


What is a put statement?

977


What are the limitations for memory allocation for SAS variables

1216


What is the function of output statement in a SAS Program?

843


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

878


what are several options for creating reports in web report studio? : Sas-bi

879


Do you need to know if there are any missing values?

834


what is the function of catx syntax? : Sas-administrator

895