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

what is sas metadata server? : Sas-di

593


How would you invoke a macro? : sas-macro

555


How do you test for missing values?

1058


How do you add a number to a macro variable? : sas-macro

545


Name few SAS functions?

668






what is proc Index? and what is proc document?

1998


In sas admin differentiate between roles and capabilities? : sas-grid-administration

556


Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

1768


how to do user inputs and command line arguments in sas?

2428


What are the ways to do a “table lookup” in sas?

593


What is the purpose of _character_ and _numeric_?

589


What is the difference between reading data from an external file and reading data from an existing data set?

636


Mention how to limit decimal places for the variable using proc means?

643


How we can call macros with in data step? : sas-macro

615


Why and when do you use proc sql?

762