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

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

1065


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1346


how many types of prompts are there? : Sas-bi

1081


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

1145


What do you understand by the term Normal Distribution?

991


Are you involved in writing the inferential analysis plan? Tables specfications?

2567


How to test the debugging in sas?

1182


What is connection profile? : sas-grid-administration

1177


What sas features do you use to check errors and data validation?

1223


Describe the function and untility of the most difficult SAS macro that you have written.

2110


I have a dataset concat having variable a b & c. How to rename a b to e & f?

1023


Have you ever used the SAS Debugger?

1762


List out some key concept of SAS

1131


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

1213


Explain the difference between nodup and nodupkey options?

1030