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...

how to remove the duplicates by proc sql?

Answer Posted / xxx

proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;

Is This Answer Correct ?    1 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain the concepts and capabilities of business object? : Sas-bi

906


Give an example where SAS fails to convert character value to numeric value automatically?

1026


what is business intelligence? : Sas-bi

1014


what is the difference between nodup and nodupkey options? : Sas programming

1112


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1867


How we can call macros with in data step? : sas-macro

1057


What is the basic structure of a sas program?

1055


How is character variable converted into numeric variable and vice versa?

1104


what are _numeric_ and _character_ and what do they do? : Sas programming

1101


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1097


what is proc Index? and what is proc document?

2629


Tell me about % include and % eval? : sas-macro

1095


which features do you use to check the data validations and errors? : Sas-administrator

998


In sas admin differentiate between roles and capabilities? : sas-grid-administration

938


What is PDV?

1093