Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are methods to identify duplicate observations?

Answer Posted / natrajboga

you can Identify the duplicate values by using
1) sort procedure along with the dupout= and nodupkey stmt
options and followed by BY stmt.
2) use the proc sql

for example:

proc sort data=demog dupout=dup_demog nodupkey;
by subjid;
run;

proc sql;

select subjid, count(*) from demog
group by subjid
having count(*)>1;
quit;

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate input and infile.

1113


What is SAS informats?

1114


How necessary is it to be creative in your work?

2488


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

1982


What are the different servers in sas? : sas-grid-administration

1064


Explain the difference between informat and format with an example.

1179


what is the effect of the options statement errors=1? : Sas programming

1071


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

2386


What are the difference between ceil and floor functions in sas?

1359


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

1177


Approximately what date is represented by the SAS date value of 730?

1220


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1071


What is the basic syntax of a sas program?

1223


how would you create multiple observations from a single observation? : Sas programming

1011


Explain translate function?

1215