Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

what do you mean by data staging area? : Sas-di

0 Answers  


What is univariate n where it can be used n how...?

2 Answers  


what are input dataset and output dataset options?

6 Answers   HCL,


Tell me more about the parameters in macro? : sas-macro

0 Answers  


What is the basic structure of the SAS base program?

0 Answers  


how we can create optional or required parameters in SAS macro...

5 Answers   TCS,


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

6 Answers  


How do you debug macros?

3 Answers   Accenture,


I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

0 Answers  


What’s the difference between var b1 – b3 and var b1 — b3?

0 Answers  


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?

0 Answers   Cognizant,


what is the use of proc sql? : Sas programming

0 Answers  


Categories