How do you delete duplicate observations in sas?



How do you delete duplicate observations in sas?..

Answer / Vinay Prakash

In SAS, you can use the `PROC SORT` and `OBSERVER` options to remove duplicate observations. Here's an example:n```n PROC SORT DATA=your_data OUT=no_duplicates;n BY variable_to_check_for_duplicates;n OBSERVE DUP = YES;n RUN;n``` This will create a new data set (`no_duplicates`) with no duplicate observations based on the specified variable.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1 Answers  


Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 Answers  


Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.

2 Answers  


Do you need to rearrange the order of the data for the report?

1 Answers  


Under what circumstances would you code a SELECT construct instead of IF statements?

4 Answers  


What is the order of evaluation of the comparison && logical && relational operators:?

2 Answers   CitiGroup,


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1 Answers  


· What are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,


Do you think professionally?

1 Answers   Oracle,


How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO

2 Answers   TCS,


I need level 2 to 5 sas using companies in india

1 Answers  


how to read the variables in sas? : Sas-administrator

1 Answers  


Categories