proc sql; select name, count(*) from data group by name having count(*)

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

Question Posted / rg

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

Please Help Members By Posting Answers For Below Questions

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4555

What is the use of the %include statement?

1145

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

1317

how does sas handle missing values in a merge? : Sas programming

1018

What makes sas stand out to be the best over other data analytics tools?

1041

what is operational data and operational system? : Sas-di

1096

How substr function works in sas?

1195

Describe a time when you were really stuck on a problem and how you solved it?

2615

What are the 3 components in sas programming?

1182

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

1084

How to create an external dataset with sas code?

1128

Enlist the functions performed by sas.

1099

Mention how to limit decimal places for the variable using proc means?

1100

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2391

What is connection profile? : sas-grid-administration

1152