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 function of output statement in a SAS Program?
explain what is factor analysis? : Sas-administrator
Define run-group processing?
Explain what is the use of proc gplot?
What is program data vector (pdv)?
What is the work of tranwrd function?
If money were no object, what would you like to do?
what is change analysis in sas di ? : Sas-di
In SAS explain which statement does not perform automatic conversions in comparisons?
What do the put and input function do?
What is program data vector (pdv) and what are its functions?
Of all your work, where have you been the most successful?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Where do you use proc means over proc freq?
What is the general format of function in sas? : sas-grid-administration
