how to remove the duplicates by proc sql?

Answer Posted / gaurav gupta

SELECT DISTINCT statement in PROC SQL

Is This Answer Correct ?    20 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

655


what is transformation in sas data integration? : Sas-di

560


What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

585


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

652


Mention the validation tools used in SAS?

658






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

583


What does PROC print, and PROC contents do?

730


what is slowly changing dimension? : Sas-di

627


What are the different operating system platforms in which we can use sas? : sas-grid-administration

594


what is function of retain statment

1526


Which statement does not perform automatic conversions in comparisons?

1205


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

1731


Describe a time when you were really stuck on a problem and how you solved it?

2207


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1103


What is substr function?

626