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

Answer Posted / m.sivakumar

data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc sort data=dups;
by var1;
run;
data dups1;
set dups;
by var1;
if not(first.var1 and last.var1) then output;
run;
proc print data=dups;
run;
proc print data=dups1;
run;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

it will become easy if uuu provide website linkssss and list of consultanciessssss

1735


Which statement does not perform automatic conversions in comparisons?

1434


What is the use of function Proc summary?

884


how does sas handle missing values in procs? : Sas programming

863


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

799


What is the difference between SAS functions and procedures?

880


What is the role of sas grid administrator? : sas-grid-administration

1044


what is star schema? : Sas-di

836


Explain proc sort?

864


What are the automatic variables for macro? : sas-macro

853


What are pdv and it functions?

761


Explain how you can debug and test your SAS program?

738


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2509


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

2310


Explain the purpose of retain statement.

791