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 to delete the duplicates by using proc sql?

Answer Posted / chowdary

In constraints time using unique
In datasets using distinct()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how sas deals with business intelligence? : Sas-bi

1056


What is program data vector (pdv) and what are its functions?

1255


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1290


explain the main difference between the nodup and nodupkey options? : Sas-administrator

1166


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2155


Mention the difference between ceil and floor functions in sas?

1160


Intern stastical programmer written test

760


Explain input and put function?

1147


what is hierarchy flattening? : Sas-di

1083


What are the applications primarily used by business analyst? : Sas-bi

1000


how do you debug and test your sas programs? : Sas programming

1132


What is the difference between the proc sql and data step?

1184


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

1202


what does the run statement do? : Sas programming

1060


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2590