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

explain the difference between proc means and proc summary?

868


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

856


do you prefer proc report or proc tabulate? Why? : Sas programming

773


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

736


how do you pull data from equifax?tell me the process?

1564


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

1809


What is the basic syntax of a sas program?

868


explain what is data set in sas? : Sas-administrator

721


what are sas bi dashboard components? : Sas-bi

864


What are the differences between sum function and using “+” operator?

790


what is change analysis in sas di ? : Sas-di

785


Describe the ways in which you can create macro variables? : sas-macro

775


What is the function of Stop statement in a SAS Program?

881


What function CATX syntax does?

876


What does proc print, and proc contents are used for?

813