Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26628 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 / chirag patel
using Nodup you can delete duplicate observation
| Is This Answer Correct ? | 4 Yes | 3 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 |
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Mention sas system options to debug sas macros.
How do you test for missing values?
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.
is data integration and etl programming is same? : Sas-di
What are the applications primarily used by business analyst? : Sas-bi
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
what is sas data set?
how to generate the test data in sas without input data? : Sas-administrator
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
how do we get duplicate observations in a separate dataset?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Teradata 
