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 DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,

what is fact table and factless table?

1 Answers  

Describe the ways in which you can create macro variables? : sas-macro

0 Answers  

How do you read in the variables that you need?

5 Answers  

Hi Friends, My name is Priya,am new to this Forum. am looking for SAS Platform Administration Interview Questions.I searched every where but I couldn't find any where.please can anyone help me with the FAQ's. It would be a great favor to me if you can email the Interview Questions to priyafeb84@gmail.com

0 Answers  

What sas features do you use to check errors and data validation?

0 Answers  

How does proc sql work?

0 Answers  

explain the key concept of sas? : Sas-administrator

0 Answers  

For what purpose(s) would use the RETURN statement?

1 Answers  

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  

who is the best SAS clinical Trainer in Hyderabad?

3 Answers  

what is function of retain statment

0 Answers   PPD,