How would you delete observations with duplicate keys?
Answer Posted / rohit
You can also use a Proc SQL statement with a Distinct
keyword.
Proc Sql;
Select Distinct tablename.* from tablename;
Quit;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what are the considerations when picking a SAS/STAT procedure?
how many display types available in sas bi dashboard? : Sas-bi
Describe what are the different levels of administrative users in sas? : sas-grid-administration
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
What is connection profile? : sas-grid-administration
In SAS explain which statement does not perform automatic conversions in comparisons?
What is the basic syntax style in SAS?
How would you determine the number of missing or nonmissing values in computations?
why is sas data integration studio important? : Sas-di
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
what is function of retain statment
Explain the main difference between the sas procedures and functions? : Sas-administrator
How do you control the number of observations and/or variables read or written?
what is hierarchy flattening? : Sas-di
For what purpose would you use the RETAIN statement?