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

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   Oracle,


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?

2 Answers   Dr Reddys, Oracle,


what type of graphs we will create(for 2+years candidates)?

0 Answers   Accenture, Icon,


What is the command used to find missing values?

0 Answers  


What are the differences between sum function and using “+” operator?

0 Answers  


How to Rename Library?

3 Answers  


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 ?

1 Answers   Satyam,


how the sas basic syntax style described? : Sas-administrator

0 Answers  


what is operational data and operational system? : Sas-di

0 Answers  


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

0 Answers  


Differences between where and if statement?

0 Answers  


what is SAS/Graph?

1 Answers   CitiGroup, NTPC,


Categories