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 is data access? : Sas-di

Describe the ways in which you can create macro variables? : sas-macro

How would you include common or reuse code to be processed along with your statements?

how do you derive descriptive statistics?

How do you convert basic cube to transaction cube and transaction cube to basic cube?

How would you identify a macro variable?

how many display types available in sas bi dashboard? : Sas-bi

what are validation tools that are used in sas? : Sas-administrator

What is difference between sas rename and lable?

what is star schema? : Sas-di

Name validation tools used in SAS

what are the sites did u refer for enquiries and doubts for SAS

For more SAS Interview Questions Click Here