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 difference between the SAS v8 and SAS v9?

7 Answers   TCS,

Why double trailing @@ is used in input statement?

0 Answers  

explain what is data set in sas? : Sas-administrator

0 Answers  

how do u validate sas program

3 Answers   Accenture,

what versions of sas have you used (on which platforms)? : Sas programming

0 Answers  

how can you get the single data set from the library(which has the number of data sets)?

3 Answers   Accenture, Deloitte,

Baseline definition in your study

3 Answers   Accenture, Quintiles,

Which is the best training institute for SAS in hyderabad.

112 Answers   Stansys Software Solutions,

Describe 5 ways to do a “table lookup” in SAS?

0 Answers  

if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

4 Answers   Accenture,

What is proc sql pass through facility?

4 Answers   L&T,

What is the difference between match merge and one to one merge?

0 Answers