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
What is the difference between SAS functions and procedures?
Which date function advances a date, time or datetime value by a given interval?
what does the run statement do? : Sas programming
Why double trailing @@ is used in input statement?
Mention few capabilities of sas framework.
What is factor analysis?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What is the basic structure of the SAS base program?
What are the automatic variables for macro? : sas-macro
How would you define the end of a macro?
What does the trace option do?
What are the table names in oracle database...?
What is the purpose of trailing @ and @@? How do you use them?
What is maximum storage capability of SAS?
What do you know about sas data set?
