Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete duplicate observations?
- 9 Answers
- 20306 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan reddy
NODUP OR NODUPREC OPTION IN PROC SORT STATEMENT.
EX;
PROC SORT DATA=EMP NODUP;
RUN;
NODUPKEY OPTION WILL ALSO DELETE THE DUPLICATE OBSERVATION
VALUES.BUT IT CAN USE THE BY VARIABLE.
EX
PROC SORT DATA=EMP NODUPKEY;
BY ENO;
RUN;
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / vijay
NODUP: in proc sort will delete duplication observations
NODUPKEY: deletes duplicate observation values of Key
variables
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ananth
nodupkey option in proc sort statement.
Or use first.byvaribale or last.byvariable in data step.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / prr
In Proc sort:
NoDupkey: TO delete duplicate observations based on By variable.
NoDuprecs: It looksup complete observation and delete
duplicate observations.
Nodup: it is a sas key word tells to sas, to delete
duplicate observations and keep only first one.
in Data step: First. and Last.
In Proc sql: Distinct Clause.
Process of SQL: 1.Select
2.group by
3.having
4.distinct
5.order by
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ganesh
When you want elemenate duplicate values from dataset using
nodup option in the procedure sort.
When you want elemenate duplicate keys from specified
variables then use nodupkey option in the procedure sort.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / reddy
nodup will eliminate the successive duplicate value only.
nodupkey eliminates all the duplicate values in a mentioned
variable.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / thirumalesh.e.
We can delete using Proc NoDupkey NoDuprecs and
NoDuplicates, then by Dupsort system option, then
if.first . last, Proc sql, create by select * unique ...
OK.
| Is This Answer Correct ? | 0 Yes | 2 No |
what is SAS/Access and SAS/Connect?what are the uses?
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
explain about data integrator metadata reports? : Sas-di
What are the data types does SAS contain?
What is the difference between order and group variable in proc report?
wat has been most common programming mistake?
What are the scrubbing procedures in sas?
How would you remove a format that has been permanently associated with a variable? ________________
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
what is the use of LRECL option.
How can sas program be validated?
what is the difference btw proc means and proc univariate?
Teradata 
