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
Mention some common errors that are usually committed in sas programming.
why is sas data integration studio important? : Sas-di
What is the command used to find missing values?
How to specify variables to be processed by the freq procedure?
Explain what is data step?
What are the table names in oracle database...?
explain the difference between proc means and proc summary?
What is the maximum and minimum length of macro variable
Are you involved in writing the inferential analysis plan? Tables specfications?
What do you know about symput and symget?
what is factor analysis? : Sas-administrator
Tell me more about the parameters in macro? : sas-macro
what does the run statement do? : Sas programming
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
how to change the execute of macro
