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 program data vector? : Sas-administrator
How to create an external dataset with sas code?
Mention what is the difference between nodupkey and nodup options?
What is the difference between order and group variable in proc report?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
: and & modifiers.
What is SAS informats?
What is the command used to find missing values?
What is the difference between %put and symbolgen? : sas-macro
What are the ways to do a “table lookup” in sas?
Difference between sum function and using “+” operator?
what are some good sas programming practices for processing very large data sets? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
What is the purpose of trailing @ and @@? How do you use them?
what is data integration? : Sas-di