How would you delete observations with duplicate keys?
Answers were Sorted based on User's Feedback
Answer / chirag patel
using Nodup you can delete duplicate observation
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ganesh
use nodupkey in proc sort automatically the duplicate key
going to delete.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ganesh
we can delete the observation by using NODUP.
proc sort data=name nodup;
by varname;
run;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / haritha
In data step first dot variable and last dot variable use
to delete the duplicate values.
by using no dup we delete the duplicate values in row wise
and no dup key is used to delete the duplicate values in
column wise it means observation
and distinct is use to delete the duplicate values in proc
sql
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / roopanwita
There is stage called Remove Duplicate to delete duplicate
record and also Sort stage do same funtion.Otherwise if
source databse is a table,then in source SQL we can select
distinct value.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / thirumalesh
NoDupKey is to delete duplicate observations based on by variables as a key variable, Noduprecs is to delete multiple observations with same values(repeated values).
also it can be done using proc sql,
and using fist and last statements in if condiotion.
Is This Answer Correct ? | 1 Yes | 0 No |
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
What are the applications primarily used by business analyst? : Sas-bi
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What do you feel about hardcoding?
Code a PROC MEANS that shows both summed and averaged output of the data.
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
In which format does Date stores in sas..? What is the use of DATE in SAS.?
For what purpose would you use the RETAIN statement?
what can you learn from the sas log when debugging? : Sas programming
Why is SAS considered self-documenting?
Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
what is sas data set?