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?
Adding 'proportion' to esttab command.Dear All, I am estimating a logistic fixed effects regression to estimate the effect of a policy ch…
stata doesn't recognize missings in string variableI want to delete observations that have missing data for a particular variable but stata does not re…
Update to -iscogen- available from SSCAn update to the iscogen package is now available from SSC. Type Code: . ssc install iscogen, repl…
Equivalent of 'exposure' variable for xtlogit regression for diff-in-diffDear All, I am running a logistic FE regression to estimate a the effect of a 'treatment' using a g…
Update to -kmatch- available from SSCA maintenance update to kmatch is now available from SSC. Type Code: . ssc install kmatch, replace…
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