proc sql; select name count from group by name; quit;

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

Question Posted / naveen

Answer Posted / naveen

proc sql;
select name count
from
group by name;
quit;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the functions which are used for character handling functions?

1120

What commands are used in the case of including or excluding any specific variables in the data set?

1075

What is the good sas programming practices for processing large data sets?

1096

What is the difference between nodupkey and nodup options?

1020

What is SAS informats?

1084

where are dashboard components are created and maintained? : Sas-bi

999

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 is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1114

What is maximum storage capability of SAS?

1406

How sas treats the dsd delimiters?

1193

what are the scrubbing procedures in sas? : Sas programming

1272

What is the maximum length of the macro variable?

1160

What is the purpose of _character_ and _numeric_?

1046

What does the trace option do?

1090