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

Answer Posted / naveen

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe a time when you were really stuck on a problem and how you solved it?

2416


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2283


Name validation tools used in SAS

904


Explain data_null_?

800


How you can read the variables that you need?

863


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1146


Define run-group processing?

785


Which statement does not perform automatic conversions in comparisons?

1439


for whom is sas data integration studio designed? : Sas-di

732


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

1092


what is business intelligence? : Sas-bi

797


What is a macro routine?

2327


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1359


What are the difficulties u faced while doing vital signs table or dataset?

2156


What is connection profile? : sas-grid-administration

885