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 / shivakrishna.yenaganti

Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;

Is This Answer Correct ?    22 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between using drop = data set option in data statement and set statement?

1205


it will become easy if uuu provide website linkssss and list of consultanciessssss

2023


Explain bmdp procedure?

1077


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1055


How necessary is it to be creative in your work?

2522


what are the best practices to process the large data sets in sas programming? : Sas-administrator

1069


Explain the difference between nodup and nodupkey options?

1081


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

1082


For clinical entire study how many tables will create approx?

2014


what is sas application server? : Sas-di

1132


explain the function of substr in sas? : Sas-administrator

1061


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

1255


How substr function works in sas?

1266


I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1811


name some data transformation used in sas di? : Sas-di

1028