How to get the repeated values by using sql in sas ?
Answer Posted / rg
proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you connect the desktop application to metadata server? : sas-grid-administration
why is sas considered self-documenting? : Sas programming
Tell me more about the parameters in macro? : sas-macro
How to test the debugging in sas?
What is the use of function Proc summary?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Do you need to rearrange the order of the data for the report?
how do you debug and test your sas programs? : Sas programming
how does sas handle missing values in sort order? : Sas programming
What do you know about sas and what we do? : sas-grid-administration
explain what is factor analysis? : Sas-administrator
How would you determine the number of missing or nonmissing values in computations?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
explain the key concept of sas? : Sas-administrator
What is the basic syntax style in SAS?