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.

Using loop to import and merge excel files
Using loop to import and merge excel files

Hi,

Please, I have 5 excel files: "File1.xls" to "File5.xls". Each file contains only 1 sheet: "Sheet1"
I want to import and merge them using variable id.
variable id uniquely identifies each observation in the excel files.

Usually, I import each file separately save them .dta, then merge. or use xls2dta to convert to. dta before merging. But I was looking for doing it with loop (foreach or forval), is that possible ? also if I have these files with completely different names (not indexed by numbers) for example instead of "File1.xls" I have "name.xls" and "File2.xls" "age.xls". is that possible?

I'm not also interested to keep the separate .dta files created before the merger

I would much appreciate your assistance on the subject.

Thank you in advance

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Using loop to import and merge excel files
Using loop to import and merge excel files

0 Response to Using loop to import and merge excel files

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Using loop to import and merge excel files Using loop to import and merge excel files

Related Posts with Using loop to import and merge excel files

0 Response to Using loop to import and merge excel files