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 is the difference between proc means and proc summary?

2 Answers   Accenture,


why a stop statement is needed for the point= option on a set statement?

0 Answers  


Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,


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

0 Answers   Oracle,


Explain how merging helps to combine data sets.

0 Answers  


In proc transpose and data step with arrays which one you pick?

0 Answers   Accenture, Quintiles,


What versions of SAS have you used (on which platforms)?

0 Answers   Quintiles,


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

0 Answers  


how do you validate sas program?

6 Answers   Accenture,


i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

0 Answers   L&T,


firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?

1 Answers  


explain what is factor analysis? : Sas-administrator

0 Answers  


Categories