How to get the repeated values by using sql in sas ?

Answer Posted / naveen

proc sql;
select name count
from
group by name;
quit;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between nodupkey and nodup options?

594


What is the role of unrestrictive users? : sas-grid-administration

571


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

840


In SAS explain which statement does not perform automatic conversions in comparisons?

801


what are the component of range? : Sas-bi

616






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

576


What can you learn from the SAS log when debugging?

918


what is star schema? : Sas-di

645


What is the basic syntax style in SAS?

619


How can you limit the variables written to output dataset in data step?

753


Explain the main difference between the sas procedures and functions? : Sas-administrator

539


What are the default statistics that proc means produce?

604


what is sas olap server? : Sas-di

689


what is business intelligence? : Sas-bi

583


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

703