How would you delete observations with duplicate keys?
Answer Posted / 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 |
Post New Answer View All Answers
explain about data integrator metadata reports? : Sas-di
where to use sas business intelligence? : Sas-bi
Explain data_null_?
What is connection profile? : sas-grid-administration
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Explain by-group processing?
Are you sensitive to code walk-throughs peer review or QC review?
What is the function of output statement in a SAS Program?
How many data types are there in SAS?
how to generate the test data in sas without input data? : Sas-administrator
How do you specify the number of iterations and specific condition within a single do loop?
What is the difference between using drop = data set option in data statement and set statement?
what is factor analysis? : Sas-administrator
How sas treats the dsd delimiters?
what do the pad and dim functions do? : Sas programming