Hi all,
I am trying to combine three DHS surveys by appending them all using following command.


use "/Users/Desktop/Paper/2008.DTA"
append using "/Users/Desktop/Paper/2013.DTA"
save "/Users/Desktop/Paper/2008_13.DTA", replace
clear
use "/Users/Desktop/Paper/2008_13.DTA"
append using "/Users/Desktop/Paper/2018.DTA"
save "/Users/Desktop/Paper/Pooled_data.DTA", replace

I get the following message:

"no room to add more variables
Up to 5,000 variables are currently allowed, although you could reset the maximum using set
maxvar; see help memory."


My memory setting is as follows:

Memory settings
set maxvar 20000 2048-32767; max. vars allowed
set matsize 10000 10-11000; max. # vars in models
set niceness 5 0-10
set min_memory 0 0-1600g
set max_memory . 32m-1600g or .
set segmentsize 32m 1m-32g

I cannot figure out what the problem is, as my total variable count is below 20000, and I can't seem to find explanation anywhere except to increase maxvar setting, which i already did.

Any help would be highly appreciated. Thanks in advance.