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 / natrajboga

use the dupout= and nodupkey options in proc sort and
followed by BY statemet with list of vars

proc sort data=xxx dupout=dup_xxx nodupkey;
by var1;
run;

/* see the log window */

proc print data=dup_xxx;
run;

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sas application server? : Sas-di

1074


What is the order of application for output data set options, input data set options and SAS statements?

1551


Compare sas with other data analytics tools.

1027


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1249


Explain input and put function?

1135


what is change analysis in sas di ? : Sas-di

1058


what is the purpose of _error_? : Sas programming

1133


Explain the difference between using drop = data set option in set and data statement?

1150


How we can call macros with in data step? : sas-macro

1120


what is the difference between nodup and nodupkey options? : Sas programming

1183


What do you understand by the term Normal Distribution?

987


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2366


What does the trace option do?

1103


I need level 2 to 5 sas using companies in india

2382


If a variable contains only numbers, can it be a character data type?

1080