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 observations with duplicate keys?

Answer Posted / rohit

You can also use a Proc SQL statement with a Distinct
keyword.

Proc Sql;
Select Distinct tablename.* from tablename;
Quit;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Intern stastical programmer written test

686


To what type of programms have you used scratch macros?

2533


Which function is used to count the number of intervals between two sas dates?

1077


what do you mean by data staging area? : Sas-di

1079


What do the PUT and INPUT functions do?

1273


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

1101


what is the difference between unique key and primary key? : Sas-di

1067


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1058


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2284


explain the concepts and capabilities of business object? : Sas-bi

916


What are the features of base sas system?

1024


List down the reasons for choosing sas over other data analytics tools.

1222


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

3905


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

969


What are the automatic variables for macro? : sas-macro

1159