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 do the in= variables improve the capability of a merge? : Sas programming

0 Answers  


What are the different servers in sas? : sas-grid-administration

0 Answers  


Name few SAS functions?

0 Answers  


What is a put statement?

0 Answers  


Explain the difference between nodup and nodupkey options?

0 Answers  


What is maximum storage capability of SAS?

0 Answers  


how would you determine the number of missing or nonmissing values in computations? : Sas programming

0 Answers  


Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

2 Answers  


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

0 Answers   Accenture, Quintiles,


Which is the best training institute for SAS in Delhi. Please reply

12 Answers   HCL, HSBC,


proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,


Explain what Proc glm does?

0 Answers  


Categories