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

What do the SAS log messages "numeric values have been converted to character" mean?

Please write codes to merge two datasets and keep every record in the first dataset.

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

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

wat has been most common programming mistake?

how many types of prompts are there? : Sas-bi

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

How sas treats the dsd delimiters?

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

explain what is factor analysis? : Sas-administrator

how do you test for missing values? : Sas programming

Explain what Proc glm does?

For more SAS Interview Questions Click Here