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 date from Excel as input in global macro
Extract date from Excel as input in global macro

Hi,

I would like to extract a date from Excel in MM/DD/YYYY format which is located in cell B2, convert it in a Stata monthly date "YYYYmMM" and put in as input in a global macro variable in Stata as monthly date, month and year:
global mdate ...
global month ...
global year ...

Anyone can help? Thanks a lot in advance.

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Extract date from Excel as input in global macro
Extract date from Excel as input in global macro

0 Response to Extract date from Excel as input in global macro

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Extract date from Excel as input in global macro Extract date from Excel as input in global macro

Related Posts with Extract date from Excel as input in global macro

0 Response to Extract date from Excel as input in global macro