Answer Posted / prr
In Proc sort:
NoDupkey: TO delete duplicate observations based on By variable.
NoDuprecs: It looksup complete observation and delete
duplicate observations.
Nodup: it is a sas key word tells to sas, to delete
duplicate observations and keep only first one.
in Data step: First. and Last.
In Proc sql: Distinct Clause.
Process of SQL: 1.Select
2.group by
3.having
4.distinct
5.order by
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Why double trailing @@ is used in input statement?
What are the different versions of sas that you have used until now? : sas-grid-administration
What are the difference between sas functions and procedures?
explain the difference between proc means and proc summary?
How do you debug and test your SAS programs?
Explain the difference between nodup and nodupkey options?
What are the uses of sas?
how does sas handle missing values in sort order? : Sas programming
Have you ever used the SAS Debugger?
What does the RUN statement do?
what are the considerations when picking a SAS/STAT procedure?
Explain proc univariate?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is maximum number of rows and cols can be handled in SAS?