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
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
how many types of prompts are there? : Sas-bi
Tell me about % include and % eval? : sas-macro
What do you understand by the term Normal Distribution?
Are you involved in writing the inferential analysis plan? Tables specfications?
How to test the debugging in sas?
What is connection profile? : sas-grid-administration
What sas features do you use to check errors and data validation?
Describe the function and untility of the most difficult SAS macro that you have written.
I have a dataset concat having variable a b & c. How to rename a b to e & f?
Have you ever used the SAS Debugger?
List out some key concept of SAS
What are the new features included in the new version of SAS Programming Language?
Explain the difference between nodup and nodupkey options?