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
how do you want missing values handled? : Sas programming
What are types of transport files?
Give some examples where proc report’s defaults are same as proc print’s defaults?
Can you explain the process of calendar?
what is data governance? : Sas-di
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
To what type of programms have you used scratch macros?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
is data integration and etl programming is same? : Sas-di
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
Describe the ways in which you can create macro variables?
what are the scrubbing procedures in sas? : Sas programming
What are the functions which are used for character handling functions?
what is sas and what are the functions? : Sas-administrator
in the flow of data step processing, what is the first action in a typical data step? : Sas programming