Interested to Buy Any Domain ? << Click Here >> for more details...
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
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
AE datasets names? how many types?
What do the SAS log messages "numeric values have been converted to character" mean?
how does sas handle missing values in a merge? : Sas programming
How do you delete duplicate observations in sas?
Mention common programming errors committed in sas ?
What does P-value signify about the statistical data?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is program data vector (pdv) and what are its functions?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What is the use of the %include statement?
Describe the function and utility of the most difficult SAS macro that you have written?
Describe the ways in which you can create macro variables?
what is the difference between infile and input? : Sas-administrator
