how to remove the duplicates by proc sql?

Answers were Sorted based on User's Feedback



how to remove the duplicates by proc sql? ..

Answer / gaurav gupta

SELECT DISTINCT statement in PROC SQL

Is This Answer Correct ?    20 Yes 3 No

how to remove the duplicates by proc sql? ..

Answer / xxx

proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More SAS Interview Questions

How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?

3 Answers   Reddy Labs,


What are Dashboard reports?And significance of these in analysis?

1 Answers  


HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,


What Proc glm does?

0 Answers  


tell me about intnx, intcx functions?

4 Answers   CitiGroup,


What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

8 Answers  


Did you used proc test? when?

0 Answers   Accenture, Quintiles,


what is the use of proc sql? : Sas programming

0 Answers  


If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?

6 Answers  


how do u identify a macro variable

5 Answers  


What is the difference between %put and symbolgen? : sas-macro

0 Answers  


Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.

2 Answers  


Categories