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 does proc print, and proc contents are used for?

1214


What is the function of Stop statement in a SAS Program?

1193


What do the SAS log messages "numeric values have been converted to character" mean?

1428


What was the last computer book you purchased? Why?

2418


what are the component of range? : Sas-bi

1147


In ARRAY processing, what does the DIM function do?

1227


What is the basic structure of a sas program?

1166


Difference between SAS STATA & SPSS?

1174


Mention what are the data types does SAS contain?

1190


how many display types available in sas bi dashboard? : Sas-bi

1141


Where do you use proc means over proc freq?

1186


How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2981


What is the differnce between SDTM 3.1.2 to 3.1.1 version

5115


what has been your most common programming mistake? : Sas programming

1183


Describe the function and utility of the most difficult SAS macro that you have written?

2625