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

Answer Posted / dilip

proc sort data=x out=y;
by v;
data m;
set y;
by v;
if first.v and last.v then delete;
run;


this is for extracting duplicate observations
from a dataset

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to remove duplicates using proc sql?

632


what is the basic structure sas administrator? : Sas-administrator

565


How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2387


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

606


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3066






Can you execute a macro within a macro? Describe. : sas-macro

676


What is the use of the %include statement?

692


What is SAS informats?

638


What do the SAS log messages "numeric values have been converted to character" mean?

892


Give some examples where proc report’s defaults are different than proc print’s defaults?

601


how could you generate test data with no input data? : Sas programming

635


What are the advantages of using sas?

611


what is data access? : Sas-di

609


what is the difference between floor and ceil functions in sas? : Sas-administrator

708


What is the basic syntax of a sas program?

671