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 default statistics that proc means produce?

967

what has been your most common programming mistake? : Sas programming

1024

how does sas handle missing values in sort order? : Sas programming

870

which date functions advances a date time or date/time value by a given interval? : Sas programming

898

what is snowflake schema? : Sas-di

1143

what r the job openings SAS for fresher graduates !

2390

What are the limitations for memory allocation for SAS variables

1423

explain the use of % includes a statement in sas? : Sas-administrator

941

what is sas database server? : Sas-di

1048

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

4420

Name validation tools used in SAS

1099

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1090

How many data types are there in SAS?

1001

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

1008

what is ae onset date n what is RDS

2457