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

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

3415


how many display types available in sas bi dashboard? : Sas-bi

1141


Describe what are the different levels of administrative users in sas? : sas-grid-administration

1080


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1135


What is connection profile? : sas-grid-administration

1228


In SAS explain which statement does not perform automatic conversions in comparisons?

1369


What is the basic syntax style in SAS?

1226


How would you determine the number of missing or nonmissing values in computations?

1128


why is sas data integration studio important? : Sas-di

1083


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1294


what is function of retain statment

2079


Explain the main difference between the sas procedures and functions? : Sas-administrator

1112


How do you control the number of observations and/or variables read or written?

1297


what is hierarchy flattening? : Sas-di

1132


For what purpose would you use the RETAIN statement?

1579