how to remove the duplicates by proc sql?

Question Posted / ram chowdary

2 Answers
8526 Views
Genpact, I also Faced
E-Mail Answers

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

Describe the ways in which you can create macro variables?

0 Answers

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

0 Answers

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers

what is change analysis in sas di ? : Sas-di

0 Answers

What do you feel about hardcoding?

3 Answers Pfizer,

What is the order of evaluation of the comparison && logical && relational operators:?

2 Answers CitiGroup,

i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

3 Answers

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?

6 Answers Accenture,

Enlist the syntax rules followed in sas statements.