Answer Posted / mohan reddy
NODUP OR NODUPREC OPTION IN PROC SORT STATEMENT.
EX;
PROC SORT DATA=EMP NODUP;
RUN;
NODUPKEY OPTION WILL ALSO DELETE THE DUPLICATE OBSERVATION
VALUES.BUT IT CAN USE THE BY VARIABLE.
EX
PROC SORT DATA=EMP NODUPKEY;
BY ENO;
RUN;
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
Do you need to know if there are any missing values?
What is the difference between the proc sql and data step?
What’s the difference between var b1 – b3 and var b1 — b3?
what are sas/access and sas/connect? : Sas programming
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what are sas bi dashboard components? : Sas-bi
What is SAS? What are the functions does it performs?
Explain the difference between using drop = data set option in set and data statement?
Tell e how how dealt with..
Tell me about % include and % eval? : sas-macro
how to debug and test the sas program? : Sas-administrator
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
for report generation which one you used proc report or data_null_?
Describe a time when you were really stuck on a problem and how you solved it?
What are the difference between the sas data step and sas procs?