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

Compare sas with other data analytics tools.

0 Answers  


WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,


why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,


How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  


Are you familiar with special input delimiters? How are they used?

4 Answers   Accenture,






Mention what are the data types does SAS contain?

0 Answers  


wat has been most common programming mistake?

3 Answers  


what is the diff b/w verification validation in sas

3 Answers   SAS,


If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

8 Answers   Accenture,


Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

4 Answers   HP, Oracle,


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

0 Answers  


What is the difference between nodupkey and nodup options?

0 Answers  


Categories