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 maximum storage capability of SAS?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What do the mod and int function do? : Sas programming
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Where do you use proc means over proc freq?
What is SAS? What are the functions does it performs?
What are the uses of sas?
What is the sas data set? : sas-grid-administration
Name few SAS functions?
how many types of prompts are there? : Sas-bi
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
How do you debug and test your SAS programs?
what is treatment emergent events and treatment emregent adverse event
what are all the reports you generated in your recent project?
How we can call macros with in data step? : sas-macro