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 would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1155


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

1107


What are the difference between sas functions and procedures?

1150


What is the role of unrestrictive users? : sas-grid-administration

1004


List out some key concept of SAS

1120


For clinical entire study how many tables will create approx?

1967


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;

2492


What are the 3 components in sas programming?

1190


What is program data vector (pdv)?

1286


What are symget and symput? : sas-macro

1312


what is factor analysis? : Sas-administrator

1097


what is study design in while working with SAS? what are screening variables in SAS?

2241


What does proc print, and proc contents are used for?

1133


how could you generate test data with no input data? : Sas programming

1185


Differentiate between format and informat? : sas-grid-administration

1058