how to display duplicated observations in a data using base
sas.

Answer Posted / aravind rangaraj

two ways u can do ot.
1. proc sort with dupout option.
2. data step:
data nodups dups;
set sample;
by x;
if first. and last. then output nodups;
else output dups;
run;
proc print data=dups;
run;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what other sas products have you used and consider yourself proficient in using? : Sas programming

673


explain the function of substr in sas? : Sas-administrator

543


What is the difference between match merge and one to one merge?

674


If a variable contains letters or special characters, can it be numeric data type?

753


Tell e how how dealt with..

1747






what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

536


What are the different versions of sas that you have used until now? : sas-grid-administration

718


What are the statements in proc sql?

581


what is star schema? : Sas-di

635


explain about various caches available in data integrator? : Sas-di

570


Describe 5 ways to do a “table lookup” in SAS?

690


how sas deals with business intelligence? : Sas-bi

573


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

535


How would you include common or reuse to be processed along with your statements?

1894


What are types of transport files?

6811