How would you delete duplicate observations?
Answer Posted / padmasri
In 3 ways we can delete the duplicate records.
1.procedure proc sort
in proc sort there are two ways to delete duplicate
observations:
* nodupkey
*noduprec
2.first. and last.
3.proc sql
these 3 ways we can delet the duplicate records in sas.
Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What versions of SAS have you used (on which platforms)?
what is data governance? : Sas-di
Mention how to limit decimal places for the variable using proc means?
Describe crosslist option in tables statement?
how do you want missing values handled? : Sas programming
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
what is the purpose of _error_? : Sas programming
how could you generate test data with no input data? : Sas programming
Name types of category in which SAS Informats are placed?
how to remove duplicates using proc sql?
What do the mod and int function do? : Sas programming
what is null hypothesis? why do you consider that?
What are the functions used for character handling?
what is the effect of the options statement errors=1? : Sas programming