Delete dublicate

Jahan zee

26 Mar 2017, 19:14

I have Variable name Company. in this company name is repeated. I want to keep each company name for once only.

company

BEIJING DEVELOPMENT

BEIJING ENTERPRISES

CHINA AGRI PRODUCTS

CHINA METAL INTN'L

CHINA OVERSEAS LAND

CHINA RESOURCES LAND

Tags: None

Marco (Shaojun) Qin

Join Date: Sep 2015

Posts: 17
#2

26 Mar 2017, 19:17

Try:
duplicates drop company, force
Comment
Clyde Schechter

Join Date: Apr 2014

Posts: 28554
#3

26 Mar 2017, 23:16

The code suggested in #1 will do what you ask. But be careful what you wish for. If there are other variables in your data, and if those variables do not contain the same values for all observations on the same company, then you will be left with a data set that has arbitrarily and irreproducibly selected certain values for those variables. Further analyses from that point will be irreproducible and, in all probability wrong. Only if you are sure that all of the other variables are consistent within company, or that you are not going to subsequently use any of the variables that aren't, is it safe to do this.
Comment
Co Ar

Join Date: Sep 2016

Posts: 80
#4

26 Mar 2017, 23:53

He can preserve first to see if there will be significant damage to his data then restore to undo the changes. Just saying..
Comment

Announcement