Hi all. I have data on the socio-economic characteristics of mayors in Brazil in 2004. Please see part of the data below.

The data display their date of birth, variable DATA_NASCIMENTO. I need to obtain their age by the time of October 1st, 2004.

The problem: in Brazil the age is expressed in day/month/year (e.g., 27061966). In the US, it is month/day/year.

Therefore, how can I calculate the age of each candidate based on the data I have?

Thank you.


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int year str30 DESCRICAO_UE str57 NOME_CANDIDATO str8 DATA_NASCIMENTO
2004 "ALFREDO VASCONCELOS"  "PEDRO MARCIANO DA SILVA"        "07051945"
2004 "ALFREDO VASCONCELOS"  "OLACIR ELY DA SILVA"            "12091955"
2004 "ALFREDO VASCONCELOS"  "M�RCIO ANT�NIO ARMOND DE SOUZA" "22091969"
2004 "ABADIA DOS DOURADOS"  "ADILBERTO RAMOS DE MOURA"       "27051965"
2004 "ABADIA DOS DOURADOS"  "ISVALDINO DE ASSUN��O"          "29091944"
2004 "ARAPORA"              "DONIZETI REZENDE BORGES"        "17051955"
2004 "ARAPORA"              "EDER ANT�NIO TEODORO"           "05041964"
2004 "ARAPORA"              "ANDR� DONIZETE MARTINS"         "09031975"
2004 "ARAPORA"              "VALDIR INACIO FERREIRA"         "12121948"
2004 "ABAETE"               "ANTONIO CARLOS LATALISA FRANCA" "02071950"
2004 "ABAETE"               "GILBERTO ALVES SOARES"          "12011963"
2004 "ABAETE"               "CL�UDIO DE SOUSA VALADARES"     "13041973"
2004 "BRASILANDIA DE MINAS" "JO�O CARDOSO DO COUTO"          "25081934"
2004 "BRASILANDIA DE MINAS" "ROMEU FONSECA TRINDADE"         "14071952"
2004 "BRASILANDIA DE MINAS" "SEBASTI�O PORTO SILV�RIO"       "08091949"
end