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

Name some categories in sas 9? : sas-grid-administration

967

How to read an input file in sas?

1128

Explain translate function?

1189

What is slibref?

1264

Give some examples where proc report’s defaults are different than proc print’s defaults?

1064

Give e an example of..

2334

what is the difference between floor and ceil functions in sas? : Sas-administrator

1246

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1906

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

1008

explain what is factor analysis? : Sas-administrator

1104

What are the default statistics that proc means produce?

1027

Explain what is SAS informats?

1082

how many types prompting framework can be broken down to? : Sas-bi

1069

For what purpose would you use the RETAIN statement?

1510

How would you include common or reuse to be processed along with your statements?

2362