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 ?

Answer Posted / rg

proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If money were no object, what would you like to do?

3204


What is the difference between one to one merge and match merge? Give an example.

1067


what is broad cast agent? : Sas-bi

1071


how would you create multiple observations from a single observation? : Sas programming

1005


how many types of prompts are there? : Sas-bi

1081


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1091


What are the advantages of using sas?

1147


what are the considerations when picking a SAS/STAT procedure?

3374


What is the maximum length of the macro variable? : sas-macro

1094


Give e an example of..

2100


describe about physical data integration? : Sas-di

1045


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1405


is data integration and etl programming is same? : Sas-di

1082


what is sas business intelligence? : Sas-bi

1180


How necessary is it to be creative in your work?

2476