I have a large number of datasets that contain 30+ of the same variables. I am attempting to append all datasets although the problem is that in one dataset a given variable is a string variable while in another dataset that same variable is a byte variable.
Take the snippet below as an example: In this data set (let's call it dataset 1) has_study, has_separatedining, has_familyroom , has_sunroom and has_rumpusroom are string variables while has_billiardroom is a byte variable. However, in dataset 2, has_billiardroom is now a string variable and perhaps has_study is now a string variable also. How do I efficiently transform all the data into the same type so that I can then append datasets?
The datasets will append only if I use the 'force' command however I lose data.
Array
I know I can convert strings to numeric variables using:
gen study = 0
replace study=1 if has_study=="TRUE"
However, given that I have such a large number of datasets and variables, this is very inefficient. I would like to run the same do.file for each dataset. Is there another way around this issue?
Related Posts with How do I make multiple variables in each dataset the same 'type' in order to append datasets and avoid losing data?
If condition between dates and a groupingHi Stata community, I am looking for some guidance on how to approach the following condition if I …
StanStandard error for wald test …
I need to explain these commands in panel regressionPlease I am new in STATA I find these commands in a paper please can you explain for me before we r…
stptime - SMR, "using data not sorted" errorHello, I have individual-level survival data for a cohort of people with my exposure variable of in…
Auto Correlation with xtabondHello, I have run an xtabond regression and have proceeded to test for auto correlation using estat …
Subscribe to:
Post Comments (Atom)
0 Response to How do I make multiple variables in each dataset the same 'type' in order to append datasets and avoid losing data?
Post a Comment