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

What are the data types in sas?

1067

What is the SAS data set?

1139

How to create list output for cross-tabulations in proc freq?

1114

What is a method to debug and test your SAS program?

1381

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4521

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1020

how does sas handle missing values in procs? : Sas programming

1262

Give e an example of..

2346

What are the different operating system platforms in which we can use sas? : sas-grid-administration

1077

What is the difference between input and infile statement?

1178

what is treatment emergent events and treatment emregent adverse event

2408

What’s the difference between var b1 – b3 and var b1 — b3?

1369

what is hash files in sas and why we are using this one in sas?

2218

Explain substr function?

1119

what do the pad and dim functions do? : Sas programming

1033