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

Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

4 Answers   HP, Oracle,

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.

10 Answers   Accenture,

Mention what is PROC in SAS?

0 Answers  

Can you explain the process of calendar?

0 Answers  

What data sets do you need to produce the report?

2 Answers   Novartis,

Name statements that function at both compile and execution time.

3 Answers   L&T,

Which are the statements whose placement in the data step is critical?

0 Answers  

Explain the difference between nodup and nodupkey options?

0 Answers  

Explain the difference between using drop = data set option in set and data statement?

0 Answers  

data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.

2 Answers  

what is Business Intelligence?

3 Answers   CitiGroup,

What is the registered Key word is sas????

2 Answers   TCS,