Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between nodup and nodupkey options?
- 20 Answers
- 79990 Views
- iFlex, Makro, Talwar, I also Faced
- E-Mail Answers
Answer Posted / majid
data test1;
input id1 $ id2 $ extra ;
cards;
aa ab 3
aa ab 1
aa ab 2
aa ab 3
;
proc sort nodup data=test1;
by id1 ;
run;
proc print data=test1;
run;
output will be like this:
Obs id1 id2 extra
1 aa ab 3
2 aa ab 1
3 aa ab 2
4 aa ab 3
*nodup" is an alias for "noduprecs" which appears to
mean "no duplicate records" but there is no way sas can
know about these duplicate records unless they, by chance,
land next to each other in sequence It is a big mistake
to think sorting "nodup" will remove duplicate records.
Sometime it will, sometime it won't. The only way you can
be sure of removing duplicate records is to "proc sort
nodupkey" and include enough key variables to be sure you
will lose the duplicates you want to lose. In the case
shown above, then if we knew of the same "extra" values
being duplicates we wanted to remove then this variable
should be included in the list of sort variables and
then "nodupkey" will remove the duplicates as shown below.
;
proc sort nodup data=test1;
by id1 id2 extra;
run;
proc print data=test1;
run;
output will be like this:
Obs id1 id2 extra
1 aa ab 1
2 aa ab 2
3 aa ab 3
so as u can see nodup eliminated all duplicate observations
if you sort them by all variables but nodupkey will show
only the duplicate observation.
proc sort nodupkey data=test1;
by id1 ;
run;
options nocenter;
proc print data=test1;
run;
output will be like this:
Obs id1 id2 extra
1 aa ab 3
| Is This Answer Correct ? | 22 Yes | 6 No |
Post New Answer View All Answers
What is interleaving in SAS?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
what is the difference between nodup and nodupkey options? : Sas programming
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
For clinical entire study how many tables will create approx?
How necessary is it to be creative in your work?
What does the trace option do?
What are symget and symput? : sas-macro
What makes sas stand out to be the best over other data analytics tools?
What are the implications?
describe about metadata object? : Sas-di
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
is data integration and etl programming is same? : Sas-di
Mention few capabilities of sas framework.
Can you execute macro within another macro? : sas-macro
