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 / prr

In Proc sort:
NoDupkey: TO delete duplicate observations based on By variable.
NoDuprecs: It looksup complete observation and delete
duplicate observations.
Nodup: it is a sas key word tells to sas, to delete
duplicate observations and keep only first one.

in Data step: First. and Last.

In Proc sql: Distinct Clause.
Process of SQL: 1.Select
2.group by
3.having
4.distinct
5.order by

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is maximum storage capability of SAS?

1351


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2055


What do the mod and int function do? : Sas programming

1128


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5378


Where do you use proc means over proc freq?

1052


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

1137


What are the uses of sas?

1166


What is the sas data set? : sas-grid-administration

919


Name few SAS functions?

1040


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

1032


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

967


How do you debug and test your SAS programs?

1500


what is treatment emergent events and treatment emregent adverse event

2325


what are all the reports you generated in your recent project?

2127


How we can call macros with in data step? : sas-macro

1057