How to get the repeated values by using sql in sas ?

Question Posted / sshivakrishna

Answers were Sorted based on User's Feedback

How to get the repeated values by using sql in sas ?..

proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;

Is This Answer Correct ?

0 Yes

0 No

How to get the repeated values by using sql in sas ?..

proc sql;
select name count
from
group by name;
quit;

Is This Answer Correct ?

0 Yes

1 No

More SAS Interview Questions

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

what is Difference between PROC SQL JOINS and MERGE?

What are the criticality that you have faced during your project in SAS?

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

how can you put a "trace" in your program? : Sas programming

Explain proc univariate?

What is the SAS data set?

How to limit decimal places for variable using proc means?

how would you create multiple observations from a single observation? : Sas programming

What do you know about sas data set?

how do you pull data from equifax?tell me the process?

What are the data types does SAS contain?

For more SAS Interview Questions Click Here