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

Answers were Sorted based on User's Feedback



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

Answer / rg

proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;

Is This Answer Correct ?    0 Yes 0 No

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

Answer / naveen

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SAS Interview Questions

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,


What are the criticality that you have faced during your project in SAS?

2 Answers  


What will calendar procedure do?

0 Answers  


What are the features of base sas system?

0 Answers  


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers  






how do u validate the program which u have written.

1 Answers   TCS,


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

0 Answers  


Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?

5 Answers   ACC,


What are _numeric_ and _character_ and what do they do?

1 Answers   Quintiles,


Explain the special input delimiters used in sas programming.

0 Answers  


How to Rename Library?

3 Answers  


what is hash files in sas and why we are using this one in sas?

0 Answers   L&T, SAS,


Categories