How to get the repeated values by using sql in sas ?
Answers were Sorted based on User's Feedback
Answer / rg
proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
Describe a time when you were really stuck on a problem and how you solved it?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
what type of graphs we will create(for 2+years candidates)?
What is the command used to find missing values?
What are the differences between sum function and using “+” operator?
How to Rename Library?
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
how the sas basic syntax style described? : Sas-administrator
what is operational data and operational system? : Sas-di
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
Differences between where and if statement?
what is SAS/Graph?