Hello,

I'm trying to add 9 variables (w_racel) for each wave of data (waves a to i) to a large dataset that contains all the other data I'm using. But it keeps coming up with r(900): 'no room to add more variables. Up to 2,048 variables are allowed with this version of Stata. Versions are available that allow up to 120,000 variables.'

However, the data only contains 340 variables

The merge command I am attempting is, for example for wave a:

Many thanks for any help,

Iz

I'm trying to add 9 variables (w_racel) for each wave of data (waves a to i) to a large dataset that contains all the other data I'm using. But it keeps coming up with r(900): 'no room to add more variables. Up to 2,048 variables are allowed with this version of Stata. Versions are available that allow up to 120,000 variables.'

However, the data only contains 340 variables

Code:

describe Contains data from C:\Users\iz9\w_all.dta obs: 86,094 Substantive data for responding adults (16+) vars: 340 28 Dec 2019 11:42 (_dta has notes)

Code:

merge 1:1 pidp using "C:\Users\iz9\a_indresp.dta", keepusing(a_racel) nogenerate

Iz

## Comment