maxvar - no room to add more variables

[Jan D Bakker]

Hi,

I encounter errror r(900) when trying to read in my data set. I am running the following code

clear
set more off
set maxvar 30000
cd "C:\Home"
use auto1.dta
append using auto2.dta

At which point I get the following error 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.



Interestingly both auto1 and auto2 contain 6860 variables. I would be happy about any thoughts.

I am running StataMP13 (64-bit) on Windows 7.

[Friedrich Huebler]

What do you get when you try the commands below?

set maxvar 30000
query memory

[Jan D Bakker]

Memory settings
set maxvar 30000 2048-32767; max. vars allowed
set matsize 400 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

[Friedrich Huebler]

Sorry, I don't understand why you get the message "Up to 5,000 variables are currently allowed".

[Jan D Bakker]

No worries. I also do not understand why I get that error message. I thought maybe anyone had a similar experience at some point or any suggestions why I get this error message.

[Friedrich Huebler]

If no one from Statalist has anything to add I would recommend contacting Stata tech support.

[Jan D Bakker]

Thanks for the advice! I will do that.

[Ho Fai Chan]

I am experiencing the exact same problem. And this only happens when I run my script on a server (Stata13-mp). The default set maxvar is set to 32767 but somehow you still cannot LOAD or APPEND dataset more the 5000 variables. Interestingly you can import csv files more than that.

[Ho Fai Chan]

correction, you can USE (LOAD) dataset more the 5000var but APPEND will still fail, so I am guessing there is a problem with the append command?

[Friedrich Huebler]

Ho Fai Chan, please follow the advice in section 12 of the FAQ.

Say exactly what you typed and exactly what Stata typed (or did) in response. N.B. exactly! If you can, reproduce the error with one of Stata's provided datasets, a small fragment of your dataset, or a simple concocted dataset that you include in your posting.