l am using the drug stock out data with the name of facility, year, number of days stocked out and the proportion of stock out, but the information of years and proportion stocked out contains some duplicates over facilities. l tried to use duplicate drop totalstock, force but l am losing some of the important information. Is there any other command that l can use so that l wont lose necessary information and at the end the data will be showing proportion stocked out over years and facility?
dataex FacilityName DaysStockedOut year totalstock
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str42 FacilityName int DaysStockedOut float(year totalstock) "AFZ Manyame Airbase hospital" 30 2011 30 "AFZ Manyame Airbase hospital" 0 2011 30 "AFZ Manyame Airbase hospital" 0 2012 0 "AFZ Manyame Airbase hospital" 0 2012 0 "AFZ Manyame Airbase hospital" 0 2013 30 "AFZ Manyame Airbase hospital" 30 2013 30 "AFZ Manyame Airbase hospital" 0 2013 30 "AFZ Manyame Airbase hospital" 0 2013 30 "AFZ Manyame Airbase hospital" 0 2014 0 "AFZ Manyame Airbase hospital" 0 2014 0 "AFZ Manyame Airbase hospital" 16 2015 16 "AFZ Manyame Airbase hospital" 0 2015 16 "AFZ Manyame Airbase hospital" 0 2015 16 "Acturus clinic" 0 2012 0 "Acturus clinic" 0 2012 0 "Acturus clinic" 0 2012 0 "Acturus clinic" 0 2013 30 "Acturus clinic" 30 2013 30 "Arda Sisi Rdc Clinic" 0 2011 0 "Arda Sisi Rdc Clinic" 0 2011 0 "Arda Sisi Rdc Clinic" 0 2012 30 "Arda Sisi Rdc Clinic" 30 2012 30 "Arda Sisi Rdc Clinic" 0 2012 30 "Arda Sisi Rdc Clinic" 0 2013 0 "Arda Sisi Rdc Clinic" 0 2013 0 "Arda Sisi Rdc Clinic" 0 2013 0 "Arda Sisi Rdc Clinic" 0 2013 0 "Arda Sisi Rdc Clinic" 90 2014 202 "Arda Sisi Rdc Clinic" 0 2014 202 "Arda Sisi Rdc Clinic" 112 2014 202 "Arda Sisi Rdc Clinic" 0 2015 14 "Arda Sisi Rdc Clinic" 0 2015 14 "Arda Sisi Rdc Clinic" 14 2015 14 "Ardura clinic" 0 2011 0 "Ardura clinic" 0 2011 0 "Ardura clinic" 0 2012 59 "Ardura clinic" 59 2012 59 "Ardura clinic" 0 2012 59 "Ardura clinic" 0 2014 0 "Ardura clinic" 0 2014 0 "Ardura clinic" 0 2015 30 "Ardura clinic" 30 2015 30 "Ardura clinic" 0 2015 30 "Avilla Mission" 0 2011 0 "Avilla Mission" 0 2011 0 "Avilla Mission" 0 2012 0 "Avilla Mission" 0 2012 0 "Avilla Mission" 0 2012 0 "Avilla Mission" 0 2012 0 "Avilla Mission" 0 2013 0 "Avilla Mission" 0 2013 0 "Avilla Mission" 0 2013 0 "Avilla Mission" 0 2014 0 "Avilla Mission" 0 2014 0 "Avilla Mission" 0 2014 0 "Avilla Mission" 0 2014 0 "Avilla Mission" 0 2015 0 "Avilla Mission" 0 2015 0 "Avilla Mission" 0 2015 0 "Avondale clinic" 0 2012 0 "Bakorenhema" 0 2011 0 "Bakorenhema" 0 2011 0 "Bakorenhema" 0 2012 60 "Bakorenhema" 30 2012 60 "Bakorenhema" 30 2012 60 "Bakorenhema" 0 2012 60 "Bakorenhema" 0 2013 0 "Bakorenhema" 0 2013 0 "Bakorenhema" 0 2013 0 "Bakorenhema" 0 2014 0 "Bakorenhema" 0 2014 0 "Bakorenhema" 0 2014 0 "Bakorenhema" 0 2015 0 "Bakorenhema" 0 2015 0 "Bakorenhema" 0 2015 0 "Bakorenhema" 0 2015 0 "Beatrice Rural Hosp" 0 2011 0 "Beatrice Rural Hosp" 0 2011 0 "Beatrice Rural Hosp" 0 2012 0 "Beatrice Rural Hosp" 0 2012 0 "Beatrice Rural Hosp" 0 2012 0 "Beatrice Rural Hosp" 0 2013 0 "Beatrice Rural Hosp" 0 2013 0 "Beatrice Rural Hosp" 0 2013 0 "Beatrice Rural Hosp" 0 2013 0 "Beatrice Rural Hosp" 0 2014 0 "Beatrice Rural Hosp" 0 2014 0 "Beatrice Rural Hosp" 30 2015 30 "BeitBridge Hosp" 0 2011 0 "BeitBridge Hosp" 0 2011 0 "BeitBridge Hosp" 0 2012 0 "BeitBridge Hosp" 0 2012 0 "BeitBridge Hosp" 0 2012 0 "BeitBridge Hosp" 0 2012 0 "BeitBridge Hosp" 50 2013 90 "BeitBridge Hosp" 40 2013 90 "BeitBridge Hosp" 10 2014 40 "BeitBridge Hosp" 0 2014 40 "BeitBridge Hosp" 0 2014 40 "BeitBridge Hosp" 30 2014 40 end
Regards
0 Response to Dropping duplicates
Post a Comment