Answer / hari prasad reddy

3 methods.
1.using proc sort
2.proc sql distinct
3.set first.var and last.var

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

Answer / sudha ramalingam

You can also use nodupkey and noduprecs in your proc sort

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;

Answer / rag_uss

use nodupkey,noduprecs,freq,distinct in sql

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

what is option year cuttoff in sas

2 Answers   L&T,

What are the automatic variables for macro? : sas-macro

0 Answers  

How do handle working under pressure?

1 Answers   Oracle, Wipro,

define table lookup and how may ways it can be done...explian

3 Answers  

What are the parameters of scan function?

0 Answers  

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

0 Answers  

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 Answers  

How does proc sql work?

0 Answers  

Name statements that function at both compile and execution time?

1 Answers  

In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

8 Answers   GSK GlaxoSmithKline,