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.

Extracting subset date from a timestamp date variable
Extracting subset date from a timestamp date variable

Dear Colleagues

Please help: I am trying to extract the first 8 characters (NEWdate) from a date format (OLDdate) which has timestamp in it.
OLDdate's format is %tc

OLDdate
14jan2011 00:00:00

NEWdate
14jan2011

I have tried the two commands below and they dont seem to work:

gen NEWdate = substr(OLDdate, 1, 9))
format NEWdate %td

gen NEWdate = dt(OLDdate_Date, 1, 9)
format NEWdate %td

Thanks for your help.

Regards

Fadzai

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Extracting subset date from a timestamp date variable
Extracting subset date from a timestamp date variable

0 Response to Extracting subset date from a timestamp date variable

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Extracting subset date from a timestamp date variable Extracting subset date from a timestamp date variable

Related Posts with Extracting subset date from a timestamp date variable

0 Response to Extracting subset date from a timestamp date variable