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

Are you involved in writing the inferential analysis plan? Tables specfications?

1845


Can you explain the process of calendar?

739


Difference between nodup and nodupkey options?

737


How do you debug and test your SAS programs?

1140


Mention some common errors that are usually committed in sas programming.

687






Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1329


what is null hypothesis? why do you consider that?

2527


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

1813


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1877


explain what is factor analysis? : Sas-administrator

689


How do you test for missing values?

1157


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1558


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

840


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

649


How long can a macro variable be? A token? : sas-macro

823