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: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

0 Answers  

what is sas metadata repository? : Sas-bi

0 Answers  

Can you suggest us materials for sdtm mapping?

0 Answers   TCS,

Difference between SAS STATA & SPSS?

0 Answers  

How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?

1 Answers   Student,

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

0 Answers   SAS,

Identify statements whose placement in the DATA step is critical.

6 Answers   Accenture, Labasol,

I have a dataset with variables empid and doj how to calculate retirement age?

1 Answers  

Do you need to know if there are any missing values?

0 Answers  

Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  

What are the statements in proc sql?

0 Answers  

How do you delete duplicate observations in sas?

0 Answers