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

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)?

1466


What is the role of unrestrictive users? : sas-grid-administration

783


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

885


What are the features of base sas system?

796


Describe crosslist option in tables statement?

943


what is program data vector? : Sas-administrator

836


What versions of SAS have you used (on which platforms)?

1253


what are some good sas programming practices for processing very large data sets? : Sas programming

718


What do the put and input function do?

791


AE datasets names? how many types?

2260


Explain what is the use of proc gplot?

912


What is slibref?

962


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

737


what is ae onset date n what is RDS

2151


How do you use the do loop if you don’t know how many times you should execute the do loop?

1007