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

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1042


Why double trailing @@ is used in input statement?

1216


What are the different versions of sas that you have used until now? : sas-grid-administration

1331


What are the difference between sas functions and procedures?

1143


explain the difference between proc means and proc summary?

1115


How do you debug and test your SAS programs?

1553


Explain the difference between nodup and nodupkey options?

1017


What are the uses of sas?

1256


how does sas handle missing values in sort order? : Sas programming

911


Have you ever used the SAS Debugger?

1750


What does the RUN statement do?

1298


what are the considerations when picking a SAS/STAT procedure?

3365


Explain proc univariate?

1025


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1191


What is maximum number of rows and cols can be handled in SAS?

1573