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 program data vector? : Sas-administrator

1018


How to create an external dataset with sas code?

1082


Mention what is the difference between nodupkey and nodup options?

969


What is the difference between order and group variable in proc report?

1378


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2209


: and & modifiers.

1344


What is SAS informats?

1061


What is the command used to find missing values?

1049


What is the difference between %put and symbolgen? : sas-macro

1177


What are the ways to do a “table lookup” in sas?

986


Difference between sum function and using “+” operator?

1098


what are some good sas programming practices for processing very large data sets? : Sas programming

884


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

2061


What is the purpose of trailing @ and @@? How do you use them?

999


what is data integration? : Sas-di

1070