How to get the repeated values by using sql in sas ?
- 2 Answers
- 4465 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rg
proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the prime responsibilities of data integration administrator? : Sas-di
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,
how do you debug and test your sas programs? : Sas programming
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
how to generate the test data in sas without input data? : Sas-administrator
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How does the internal authentication work in sas? : sas-grid-administration
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Name statements that are execution only.
Name some categories in sas 9? : sas-grid-administration
Describe a time when you were really stuck on a problem and how you solved it?
What is SAS Information Map Studio and its purpose ?
Teradata 
