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 are the default statistics that proc means produce?

604


Explain the purpose of substr functions in sas programming.

561


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

680


What would be the value of month at the end of data step execution and how many observations would be there?

576


List out some key concept of SAS

619






Differentiate input and infile.

594


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

608


I need level 2 to 5 sas using companies in india

1927


where to use sas business intelligence? : Sas-bi

580


Describe the function and untility of the most difficult SAS macro that you have written.

1558


for whom is sas data integration studio designed? : Sas-di

556


What is PROC in SAS?

604


State the difference between INFORMAT and FORMAT ?

595


what is the Population you used in your project, is it ITT or PP?

2179


This entry was posted in General. Bookmark the permalink. Post a comment or leave

4029