Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26100 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 |
how to read character value without using substr function in sas ?
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
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.
What are the data types in sas?
which stats created by proc means that are not created by proc summary or vice versa?
What is difference between N and n????
Explain how you can debug and test your SAS program?
what are informats in sas? : Sas-administrator
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
how to write code for left outer join in SAs using datastep?
explain about data integrator metadata reports? : Sas-di
Teradata 
