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 / mohan reddy

NODUP OR NODUPREC OPTION IN PROC SORT STATEMENT.
EX;
PROC SORT DATA=EMP NODUP;
RUN;

NODUPKEY OPTION WILL ALSO DELETE THE DUPLICATE OBSERVATION
VALUES.BUT IT CAN USE THE BY VARIABLE.

EX

PROC SORT DATA=EMP NODUPKEY;
BY ENO;
RUN;

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you need to know if there are any missing values?

1035


What is the difference between the proc sql and data step?

1169


What’s the difference between var b1 – b3 and var b1 — b3?

1356


what are sas/access and sas/connect? : Sas programming

989


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2580


what are sas bi dashboard components? : Sas-bi

1166


What is SAS? What are the functions does it performs?

1190


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

1150


Tell e how how dealt with..

2219


Tell me about % include and % eval? : sas-macro

1138


how to debug and test the sas program? : Sas-administrator

1033


What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1034


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

7772


Describe a time when you were really stuck on a problem and how you solved it?

2633


What are the difference between the sas data step and sas procs?

1179