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 |
what do you mean by data staging area? : Sas-di
What is univariate n where it can be used n how...?
what are input dataset and output dataset options?
Tell me more about the parameters in macro? : sas-macro
What is the basic structure of the SAS base program?
how we can create optional or required parameters in SAS macro...
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
How do you debug macros?
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
What’s the difference between var b1 – b3 and var b1 — b3?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
what is the use of proc sql? : Sas programming