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.

Append and recode multiple datasets at once
Append and recode multiple datasets at once

Hi,
I am fairly new to stata and am trying to figure out a way where I can recode variables across multiple datasets and have the new recoded variables be saved into 1 aggregate data file. For context, I have 14 files all named: file_1.dta , file_2.dta, .... file_14.dta
For this example, I have a variable MCREV06 where the 06 is the given year

Code:

cd "/Users/octavio/Desktop/MEPS"
clear
foreach i in file_1.dta file_2.dta file_3.dta file_4.dta file_5.dta file_7.dta file_8.dta file_9.dta file_10.dta file_11.dta file_12.dta file_13.dta file_14.dta {
use file_`i'.dta
keep MCREV`num'
gen EVERMEDICARE=0
replace EVERMEDICARE=1 if MCREV`num'==1
append using file_`i'
save aggregatedatafile

}

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Append and recode multiple datasets at once
Append and recode multiple datasets at once

0 Response to Append and recode multiple datasets at once

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Append and recode multiple datasets at once Append and recode multiple datasets at once

Related Posts with Append and recode multiple datasets at once

0 Response to Append and recode multiple datasets at once