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?

636


how does sas handle missing values in procs? : Sas programming

634


how do you want missing values handled? : Sas programming

532


Explain input and put function?

643


How we can create SAS USER DEFINED CODE?

1609






What are common programming errors committed in sas

667


Describe the ways in which you can create macro variables? : sas-macro

574


In sas, what are the areas that you are most interested in? : sas-grid-administration

634


What will calendar procedure do?

593


do you prefer proc report or proc tabulate? Why? : Sas programming

570


Explain data step in SAS

627


Intern stastical programmer written test

282


How do you define proc in sas? : sas-grid-administration

668


How to read an input file in sas?

652


Difference between SAS STATA & SPSS?

676