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 is the purpose of _character_ and _numeric_?

1109

What is the SAS data set?

1178

what are some differences between proc summary and proc means? : Sas programming

1195

Explain translate function?

1260

For what purpose would you use the RETAIN statement?

1586

Mention common programming errors committed in sas ?

1173

what is program data vector? : Sas-administrator

1126

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2154

What is the order of application for output data set options, input data set options and SAS statements?

1620

What do you code to create a macro? : sas-macro

1193

To what type of programms have you used scratch macros?

2610

what is information maps?

2283

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

1964

Describe crosslist option in tables statement?

1269

Given an unsorted data set, how to read the last observation to a new data set?

1411