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

Baseline definition in your study

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

Difference between SAS STATA & SPSS?

Can you execute a macro within a macro? Describe. : sas-macro

what is the use of sas management console? : Sas-di

what has been your most common programming mistake? : Sas programming

what is Global Symbol table and Local symbol table?

What are the data types does SAS contain?

how can you sort the dataset having millions of OBS(instead of sort procedure?

how can u extract,transform and loading?

how does sas handle missing values in an update? : Sas programming

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

For more SAS Interview Questions Click Here