BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Thursday, April 29, 2021

extract the year from an inconsistent string date variable

Hi everyone,

I am having troubles extracting the year from my dateset. Some observations have the formal d/m/y, while others have only the year.

I tried the following
encode Acquirordateofincorporation, gen(Age)
generate AcquirorAge = yofd(Age)
gen AGE=(2021-AcquirorAge)

I also tried gen Year=real(substr(Acquirordateofincorporation)), but it doesnt work.

Any help would be highly valuable.

Thank You!

Iulia

BJ Data Tech Solution

Thursday, April 29, 2021

extract the year from an inconsistent string date variable

No comments:

Post a Comment