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 do we get duplicate observations in a separate dataset?

Answer Posted / rajaanku11

proc sql;
create table dup_obs as (
select * from <lib>.<dsn>
group by <dup var>,<list of other vars>
having count(*)>1 )
quit;

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2240


List down the reasons for choosing sas over other data analytics tools.

1213


What are the automatic variables for macro? : sas-macro

1140


What is proc sort?

1134


explain about sas business intelligence? : Sas-bi

1074


What is maximum number of rows and cols can be handled in SAS?

1473


What is the work of tranwrd function?

1179


How to limit decimal places for variable using proc means?

1044


Explain append procedure?

1023


for report generation which one you used proc report or data_null_?

7624


how do you want missing values handled? : Sas programming

898


What is the sas data set? : sas-grid-administration

920


What is interleaving in SAS?

1063


why is sas data integration studio important? : Sas-di

976


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5379