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

how do you pull data from equifax?tell me the process?

1562


How can sas program be validated?

769


Tell me more about the parameters in macro? : sas-macro

808


Differentiate input and infile.

817


For what purpose would you use the RETAIN statement?

1263


what is enterprise guide? What is the use of it? : Sas programming

746


Differentiate between proc means and proc summary.

777


What are the difference between sas functions and procedures?

837


what are the scrubbing procedures in sas? : Sas programming

1049


it will become easy if uuu provide website linkssss and list of consultanciessssss

1739


what other sas products have you used and consider yourself proficient in using? : Sas programming

883


why is sas considered self-documenting? : Sas programming

858


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

821


What are the default statistics that proc means produce?

789


for report generation which one you used proc report or data_null_?

7104