how to delete the duplicates by using proc sql?
Answer Posted / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is SAS?
What are the data types does SAS contain?
What do the PUT and INPUT functions do?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
How would you invoke a macro? : sas-macro
how does sas handle missing values in assignment statements? : Sas programming
Explain the use of proc gplot? : sas-grid-administration
Compare sas with other data analytics tools.
what is the effect of the options statement errors=1? : Sas programming
What is PROC in SAS?
Mention what is PROC in SAS?
How to create a permanent sas data set?
What is the use of stop statement?
How would you determine the number of missing or nonmissing values in computations?
What is the basic syntax style in SAS?