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 does the run statement do? : Sas programming

1102

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1316

How to specify variables to be processed by the freq procedure?

1116

What is the difference between where and if statement?

1149

why is a stop statement needed for the point=option on a set statement? : Sas programming

1128

What areas of SAS are you most interested in?

1578

What is the function of output statement in a SAS Program?

1121

how many types of prompts are there? : Sas-bi

1123

What is the basic syntax of a sas program?

1260

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1152

Describe crosslist option in tables statement?

1263

what is sas olap server? : Sas-di

1293

What is the basic structure of the SAS base program?

1394

what is treatment emergent events and treatment emregent adverse event

2448

What are the uses of sas?

1357