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 does sas handle missing values in a merge? : Sas programming

991


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2071


Name types of category in which SAS Informats are placed?

1102


What is a method to debug and test your SAS program?

1286


In SAS explain which statement does not perform automatic conversions in comparisons?

1274


Explain by-group processing?

954


What do you code to create a macro? : sas-macro

1080


which features do you use to check the data validations and errors? : Sas-administrator

1013


What is slibref?

1218


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

7649


what is factor analysis? : Sas-administrator

1034


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1204


What are the difficulties u faced while doing vital signs table or dataset?

2349


Intern stastical programmer written test

688


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

1089