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

is it possible to generate sas datasets using proc print ???

What r all the reporting procedures...?

What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

In proc transpose and data step with arrays which one you pick?

What is the function of Stop statement in a SAS Program?

What is _n_?

do you prefer proc report or proc tabulate? Why? : Sas programming

Approximately what date is represented by the SAS date value of 730?

What is the maximum length of the macro variable? : sas-macro

What are the applications primarily used by business analyst? : Sas-bi

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

what is a post baseline?

For more SAS Interview Questions Click Here