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

how do you want missing values handled? : Sas programming

898


What are types of transport files?

7861


Give some examples where proc report’s defaults are same as proc print’s defaults?

1054


Can you explain the process of calendar?

1057


what is data governance? : Sas-di

970


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

1169


To what type of programms have you used scratch macros?

2526


what are 5 ways to perform a table lookup in sas? : Sas-administrator

1179


is data integration and etl programming is same? : Sas-di

1008


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

1723


Describe the ways in which you can create macro variables?

1110


what are the scrubbing procedures in sas? : Sas programming

1222


What are the functions which are used for character handling functions?

1078


what is sas and what are the functions? : Sas-administrator

931


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1014