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

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

0 Answers  

Tell e how how dealt with..

0 Answers   Wipro,

6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK

1 Answers   IBM, SAS,

What is the order of evaluation of the following operators + - * / ** () ???

2 Answers  

Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation

1 Answers   SAS,

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

How substr function works in sas?

0 Answers  

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 Answers  

what are several options for creating reports in web report studio? : Sas-bi

0 Answers  

Name statements that are recognized at compile time only?

3 Answers   Accenture,

In which format does Date stores in sas..? What is the use of DATE in SAS.?

3 Answers   TCS,

Explain the main difference between the sas procedures and functions? : Sas-administrator

0 Answers