What is the difference between nodup and nodupkey options?
Answer Posted / chiranjeevi
nodup:
By using the proc sort procedure along with nodup
option ,it checks for and eliminates the duplicate records.
nodupkey:
NODUPKEY eliminates the duplicate observation keys
in the data set.
Is This Answer Correct ? | 19 Yes | 17 No |
Post New Answer View All Answers
What are common programming errors committed in sas
name some data transformation used in sas di? : Sas-di
Differentiate input and infile.
how can you put a "trace" in your program? : Sas programming
What do the PUT and INPUT functions do?
Explain what is SAS informats?
What is the basic syntax of a sas program?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Mention common programming errors committed in sas ?
what type of graphs we will create(for 2+years candidates)?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What are symget and symput? : sas-macro
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what are validation tools that are used in sas? : Sas-administrator
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.