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 mod and int function do? What do the pad and dim functions do? : Sas programming

What are TEAEs

what are methods to identify duplicate observations?

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

what type of reports you are generating in your company...???

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

how does sas handle missing values in functions? : Sas programming

explain the key concept of sas? : Sas-administrator

How do you add a number to a macro variable?

What is a post baseline?

describe about physical data integration? : Sas-di

Describe the ways in which you can create a macro variable?

For more SAS Interview Questions Click Here