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
what does the run statement do? : Sas programming
What are the functions used for character handling?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
what are input dataset and output dataset options? : Sas programming
What are the differences between sum function and using “+” operator?
what are all the reports you generated in your recent project?
Explain how you can debug and test your SAS program?
explain what is data set in sas? : Sas-administrator
What is Linear Regression?
What is program data vector (pdv)?
What are the functions which are used for character handling functions?
what is the difference between nodup and nodupkey options? : Sas programming
how could you generate test data with no input data? : Sas programming
Explain the use of proc print and proc contents?