how to delete the duplicates by using proc sql?

Answer Posted / chowdary

In constraints time using unique
In datasets using distinct()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

describe about metadata object? : Sas-di

621


How would you determine the number of missing or nonmissing values in computations?

646


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

2179


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

640


How to include or exclude specific variables in a data set?

642






what can you learn from the sas log when debugging? : Sas programming

606


what is data governance? : Sas-di

621


Tell e how how dealt with..

1752


Mention the difference between ceil and floor functions in sas?

644


Explain the purpose of substr functions in sas programming.

561


Explain substr function?

572


Explain what is data step?

727


explain the use of % includes a statement in sas? : Sas-administrator

543


How to limit decimal places for variable using proc means?

587


Can you suggest us materials for sdtm mapping?

4035