Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26104 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 the limit of the number of the rows and columns available in the worksheet? : Sas-bi
How does the internal authentication work in sas? : sas-grid-administration
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
How to test the debugging in sas?
Difference between SAS STATA & SPSS?
Mention what is PROC in SAS?
What are the criticality that you have faced during your project in SAS?
What is a macro routine?
Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 Answers Verinon Technology Solutions,
Teradata 
