Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between nodup and nodupkey options?
- 20 Answers
- 79891 Views
- iFlex, Makro, Talwar, I also Faced
- E-Mail Answers
Answer Posted / stopby
The Nodup: can only remove the duplicate next to each other.
The by variables are very important for remove
the duplicates which all the variables have the same value.
The nodupkey: will remove the duplicated when they have the
same values for the by variables
| Is This Answer Correct ? | 43 Yes | 3 No |
Post New Answer View All Answers
Which statement does not perform automatic conversions in comparisons?
what do you mean by data staging area? : Sas-di
How are numeric and character missing values represented internally?
What are the applications primarily used by business analyst? : Sas-bi
What is the SAS data set?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What is the basic structure of the SAS base program?
What is the difference between %put and symbolgen? : sas-macro
what is transformation in sas data integration? : Sas-di
how do you debug and test your sas programs? : Sas programming
what is data governance? : Sas-di
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
what can you learn from the sas log when debugging? : Sas programming
How to create list output for cross-tabulations in proc freq?
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.
