How would you delete observations with duplicate keys?
Answer Posted / haritha
In data step first dot variable and last dot variable use
to delete the duplicate values.
by using no dup we delete the duplicate values in row wise
and no dup key is used to delete the duplicate values in
column wise it means observation
and distinct is use to delete the duplicate values in proc
sql
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you test for missing values?
how to read the variables in sas? : Sas-administrator
Tell e how how dealt with..
What is factor analysis?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What do you know about sas and what we do? : sas-grid-administration
What is the difference between INPUT and INFILE ?
how do you want missing values handled? : Sas programming
What is the command used to find missing values?
: and & modifiers.
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
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
how the sas basic syntax style described? : Sas-administrator
What is the difference between %put and symbolgen? : sas-macro
Mention the difference between ceil and floor functions in sas?