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?

Answers were Sorted based on User's Feedback



how to delete the duplicates by using proc sql?..

Answer / shivakrishna.yenaganti

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

Is This Answer Correct ?    22 Yes 2 No

how to delete the duplicates by using proc sql?..

Answer / arpit

proc sql;
select distinct (*) from sasuser.xyz;
quit.

Is This Answer Correct ?    6 Yes 0 No

how to delete the duplicates by using proc sql?..

Answer / chowdary

In constraints time using unique
In datasets using distinct()

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SAS Interview Questions

How are numeric and character missing values represented internally?

0 Answers   Quintiles,


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

0 Answers  


Describe 5 ways to do a “table lookup” in SAS?

0 Answers  


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

0 Answers  


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

0 Answers  


Give an example where SAS fails to convert character value to numeric value automatically?

0 Answers  


In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?

6 Answers  


how can u convert this 25-jul-2010 from numeric to charcter?

3 Answers  


In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  


Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  


how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  


tell me about intnx, intcx functions?

4 Answers   CitiGroup,


Categories