Interested to Buy Any Domain ? << Click Here >> for more details...
what are methods to identify duplicate observations?
- 5 Answers
- 11219 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 |
Briefly describe 5 ways to do a "table lookup" in sas.
what is snowflake schema? : Sas-di
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
in ods is there any lib's
Mention few ways with which a “table lookup’ is done in sas programming.
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
Mention the validation tools used in SAS?
Tell e how how dealt with..
how to change the execute of macro
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
how to know the attributes of first five datasets in a library
How do you add a number to a macro variable? : sas-macro
Teradata 
