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.

extract the year from an inconsistent string date variable
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

Home / Data Cleaning / Data management / Data Processing / extract the year from an inconsistent string date variable
extract the year from an inconsistent string date variable

0 Response to extract the year from an inconsistent string date variable

Post a Comment

Home / Data Cleaning / Data management / Data Processing / extract the year from an inconsistent string date variable extract the year from an inconsistent string date variable

Related Posts with extract the year from an inconsistent string date variable

0 Response to extract the year from an inconsistent string date variable