Interested to Buy Any Domain ? << Click Here >> for more details...
what are methods to identify duplicate observations?
- 5 Answers
- 11019 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari prasad reddy
3 methods.
1.using proc sort
2.proc sql distinct
3.set first.var and last.var
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / ramesh sas trainar in stg
1.Proc Sort
2.Proc SQL Distinct
3.first.byvariable
4.last.byvariable
5.proc freq
6.Proc SQL unique
7.merge Statement
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sudha ramalingam
You can also use nodupkey and noduprecs in your proc sort
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / natrajboga
you can Identify the duplicate values by using
1) sort procedure along with the dupout= and nodupkey stmt
options and followed by BY stmt.
2) use the proc sql
for example:
proc sort data=demog dupout=dup_demog nodupkey;
by subjid;
run;
proc sql;
select subjid, count(*) from demog
group by subjid
having count(*)>1;
quit;
| Is This Answer Correct ? | 6 Yes | 4 No |
What is the difference between %local and %global? : sas-macro
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
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
How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?
What is the one statement to set the criteria of data that can be coded in any step?
How to create an external dataset with sas code?
How we can create SAS USER DEFINED CODE?
what is the difference between SET and MERGE?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What sas features do you use to check errors and data validation?
Teradata 
