How would you delete observations with duplicate keys?
Answers were Sorted based on User's Feedback
Answer / sastechies
2 ways
1.Proc Sort with Dupkey and Noduprecs options
2.Datastep using a combination of first.var and last.var
variables...
However one common mistake one might do with Proc Sort
NoDup here is that missing all the variables in the By
statement..
Read here...
http://sastechies.blogspot.com/2009/12/common-programming-
mistake-with-proc.html
| Is This Answer Correct ? | 0 Yes | 0 No |
how do you debug and test your sas programs? : Sas programming
What is the difference between where and if statement?
You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What are the difference between sas functions and procedures?
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
For what purpose would you use the RETAIN statement?
How will you generate test data with no input data?
do you prefer proc report or proc tabulate? Why? : Sas programming
Briefly describe 5 ways to do a "table lookup" in sas.
SAS using companies in chennai
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma