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


Please Help Members By Posting Answers For Below Questions

what does the run statement do? : Sas programming

548


What are the functions used for character handling?

632


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

528


what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

537


what are input dataset and output dataset options? : Sas programming

551






What are the differences between sum function and using “+” operator?

565


what are all the reports you generated in your recent project?

1672


Explain how you can debug and test your SAS program?

559


explain what is data set in sas? : Sas-administrator

518


What is Linear Regression?

678


What is program data vector (pdv)?

625


What are the functions which are used for character handling functions?

603


what is the difference between nodup and nodupkey options? : Sas programming

611


how could you generate test data with no input data? : Sas programming

614


Explain the use of proc print and proc contents?

548