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 would you delete duplicate observations?

Answer Posted / mehul thakkar

There are two ways of deleting the records from the dataset
with the help of PROC SORT.
1. Using NODUP/NODUPRECS
2. Using NODUPKEY

The first option deletes the records only if all the
variables values are repeated in the subsequent records.

The second options deletes the records only if the value of
the BY variables given in the BY clause are repeated in the
subsequent records.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to limit decimal places for variable using proc means?

1115


How long can a macro variable be? A token? : sas-macro

1218


What are the new features included in the new version of SAS Programming Language?

1214


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1801


What are the different types of sas functions?

1286


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1068


Do you know the features of sas?

1047


How does the internal authentication work in sas? : sas-grid-administration

1129


Explain how merging helps to combine data sets.

1059


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?

2936


what is the purpose of _error_? : Sas programming

1145


explain what is factor analysis? : Sas-administrator

1118


What are the default statistics for means procedure?

1253


What commands are used in the case of including or excluding any specific variables in the data set?

1098


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2373