# Erreur de compilation
**URL:** https://forum.dynare.org/t/erreur-de-compilation/21810
**Category:** Stochastic simulations
**Created:** [20 January 2023 22:08 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810 "2023-01-20T22:08:34Z")
**Posts on this page:** 20
**Page:** 2
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [7 February 2023 21:45 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/21 "2023-02-07T21:45:11Z")
it is done here is the message that I receive:
Error using load\_m\_file\_data\_legacy
Some variables are missing (A B CNR CR G IG IP KG KP LNR LR PI R RB T TRANS U W Y tau\_c tau\_k tau\_l)!
Error in makedataset (line 126)
DynareDataset = load\_m\_file\_data\_legacy(datafile, DynareOptions.varobs);
Error in dynare\_estimation\_init (line 553)
[dataset\_, dataset\_info, newdatainterfaceflag] = makedataset(options\_, options\_.dsge\_var\*options\_.dsge\_varlag, gsa\_flag);
Error in dynare\_estimation\_1 (line 110)
dynare\_estimation\_init(var\_list\_, dname, [], M\_, options\_, oo\_, estim\_params\_, bayestopt\_);
Error in dynare\_estimation (line 118)
dynare\_estimation\_1(var\_list,dname);
Error in limsa.driver (line 667)
oo\_recursive\_=dynare\_estimation(var\_list\_);
Error in dynare (line 281)
evalin(‘base’,[fname ‘.driver’]);
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [12 February 2023 17:50 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/22 "2023-02-12T17:50:22Z")
Does your data file contain proper variable names?
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [13 February 2023 18:38 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/23 "2023-02-13T18:38:42Z")
not really
I will send you my excel file and my git so you can clarify the problems
[sal.mod](https://forum.dynare.org/uploads/short-url/cLx0X1sGJdIUcM4MrUrm7eyObGK.mod) (8.4 KB)
[base DSGE.xlsx](https://forum.dynare.org/uploads/short-url/o7HnTA0REDQsxPLMVkJeArHLp1x.xlsx) (12.0 KB)
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [14 February 2023 15:40 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/24 "2023-02-14T15:40:21Z")
Use [sal.mod](https://forum.dynare.org/uploads/short-url/sddmLPOhjTx9V7nYLtreszICPc8.mod) (8.4 KB)
Now you have the issue in
> [@DSGE modelling: The forecast error variance in the multivariate Kalman filter became singular](https://forum.dynare.org/t/dsge-modelling-the-forecast-error-variance-in-the-multivariate-kalman-filter-became-singular/21749/4):
>
> You have standard stochastic singularity. Try dropping one variable at a time. Search the forum for details.
The problem is that you are observing all elements of
```auto
Yss*Y = Css*C + IPss*IP + IGss*IG + Gss*G;
```
---
### Author:  [@peedahai](https://forum.dynare.org/u/peedahai)
#### Post date: [15 February 2023 05:58 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/25 "2023-02-15T05:58:34Z")
thank you very much Professor Johaness, i will take a look at it
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [16 February 2023 20:39 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/26 "2023-02-16T20:39:18Z")
so I have to remove IPss or what?
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [16 February 2023 22:59 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/27 "2023-02-16T22:59:55Z")
Professor Johaness
I think my git is perfect
the main problem comes from my database the message that appears after launching the git is the following:
Error using makedataset
makedataset: I can’t find a datafile (with allowed extension m, mat, csv, xls or xlsx)!
Error in dynare\_estimation\_init (line 553)
[dataset\_, dataset\_info, newdatainterfaceflag] = makedataset(options\_, options\_.dsge\_var\*options\_.dsge\_varlag, gsa\_flag);
Error in dynare\_estimation\_1 (line 110)
dynare\_estimation\_init(var\_list\_, dname, [], M\_, options\_, oo\_, estim\_params\_, bayestopt\_);
Error in dynare\_estimation (line 118)
dynare\_estimation\_1(var\_list,dname);
Error in henri\_ngah.driver (line 517)
oo\_recursive\_=dynare\_estimation(var\_list\_);
Error in dynare (line 281)
evalin(‘base’,[fname ‘.driver’]);
explain me step by step how I can insert the database i tried the three methods : import the data, generate the data and generate livee data.
here is my git and my database
[base DSGE.xlsx](https://forum.dynare.org/uploads/short-url/o7HnTA0REDQsxPLMVkJeArHLp1x.xlsx) (12.0 KB)
[mohamedS.mod](https://forum.dynare.org/uploads/short-url/cKppwE5BdfOCQJxT6EQz7gjcwY9.mod) (8.0 KB)
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [17 February 2023 00:18 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/28 "2023-02-17T00:18:05Z")
my data contains the variables Y C G IG Sm IP
but I still get this massage!
Error using load\_m\_file\_data\_legacy
Some variables are missing (C G IG IP Sm Y)!
Error in makedataset (line 126)
DynareDataset = load\_m\_file\_data\_legacy(datafile, DynareOptions.varobs);
Error in dynare\_estimation\_init (line 553)
[dataset\_, dataset\_info, newdatainterfaceflag] = makedataset(options\_, options\_.dsge\_var\*options\_.dsge\_varlag, gsa\_flag);
Error in dynare\_estimation\_1 (line 110)
dynare\_estimation\_init(var\_list\_, dname, [], M\_, options\_, oo\_, estim\_params\_, bayestopt\_);
Error in dynare\_estimation (line 118)
dynare\_estimation\_1(var\_list,dname);
Error in mohamedS.driver (line 636)
oo\_recursive\_=dynare\_estimation(var\_list\_);
Error in dynare (line 281)
evalin(‘base’,[fname ‘.driver’]);
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [17 February 2023 16:03 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/29 "2023-02-17T16:03:36Z")
You again deleted the `xls_range` I previously added.
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [17 February 2023 17:55 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/30 "2023-02-17T17:55:28Z")
the problem is that matlab does not recognize the variables observed in my data
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [17 February 2023 18:04 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/31 "2023-02-17T18:04:07Z")
You are not listening carefully. You need to specify `xls_range=D1:I22`. Also, you need to provide the most recent files that cause issues. Your last upload has a totally different set of `varobs`.
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [17 February 2023 18:36 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/32 "2023-02-17T18:36:46Z")
excuse me really, if I understand well I just import the database without generating a git and I place rangeD1:I22 and I specify the varobs in the same estimation git that is in the same line?
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [17 February 2023 18:47 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/33 "2023-02-17T18:47:55Z")
proffesor Johaness excuse me really
I’ll pass you my recent git and excel sheet
please try to correct the problem
[base DSGE.xlsx](https://forum.dynare.org/uploads/short-url/o7HnTA0REDQsxPLMVkJeArHLp1x.xlsx) (12.0 KB)
[mohamedSALIM.mod](https://forum.dynare.org/uploads/short-url/5B6cRJEboLCbQK8agtYMpFwTmir.mod) (8.0 KB)
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [19 February 2023 22:23 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/34 "2023-02-19T22:23:32Z")
You declared
```auto
varobs tau_c tau_l B;
```
as observed, but none of those is actually contained in the Excel file.
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [19 February 2023 23:09 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/35 "2023-02-19T23:09:34Z")
the variables in my excel sheet are Y C IG IP Sm G
I declared these last ones as varobs
but I still get the following message:
Error using load\_m\_file\_data\_legacy
Some variables are missing (C G IG IP Sm Y)!
Error in makedataset (line 126)
DynareDataset = load\_m\_file\_data\_legacy(datafile, DynareOptions.varobs);
Error in dynare\_estimation\_init (line 553)
[dataset\_, dataset\_info, newdatainterfaceflag] = makedataset(options\_, options\_.dsge\_var\*options\_.dsge\_varlag, gsa\_flag);
Error in dynare\_estimation\_1 (line 110)
dynare\_estimation\_init(var\_list\_, dname, [], M\_, options\_, oo\_, estim\_params\_, bayestopt\_);
Error in dynare\_estimation (line 118)
dynare\_estimation\_1(var\_list,dname);
Error in mohamedSALIM.driver (line 635)
oo\_recursive\_=dynare\_estimation(var\_list\_);
Error in dynare (line 281)
evalin(‘base’,[fname ‘.driver’]);
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [20 February 2023 13:33 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/36 "2023-02-20T13:33:19Z")
> [@swasss](#):
>
> the variables in my excel sheet are Y C IG IP Sm G
> I declared these last ones as varobs
You need to be more careful in your work. That’s not what the code you uploaded does.
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [21 February 2023 03:57 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/37 "2023-02-21T03:57:24Z")
agree Professor Pfeifer
let’s try with this git and this base:
[base\_dsge\_salim.xlsx](https://forum.dynare.org/uploads/short-url/5RKI8EvC1ncVRjyzIEkJvVrbPF8.xlsx) (12.3 KB)
[salim.mod](https://forum.dynare.org/uploads/short-url/qYwiow8kHHOoc6pu3uGGcIqwuq0.mod) (11.1 KB)
please try to modify it. Thank you very much and again I apologize for the inconvenience
---
### Author:  [@jpfeifer](https://forum.dynare.org/u/jpfeifer)
#### Post date: [21 February 2023 14:38 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/38 "2023-02-21T14:38:47Z")
You again deleted the `xls_range` and provided an incorrect name for the data file. See also
> [@A persisting error in Dynare Octave DSGE model](https://forum.dynare.org/t/a-persisting-error-in-dynare-octave-dsge-model/21915/6):
>
> It seems you did not add proper observation equations to your model. Your data is still trending. Please read See [Pfeifer(2013): “A Guide to Specifying Observation Equations for the Estimation of DSGE Models”](https://drive.google.com/file/d/1r89OU5OE3CBa6tOlj6l3hNVWEaRH5Anv/view?usp=sharing)
---
### Author:  [@peedahai](https://forum.dynare.org/u/peedahai)
#### Post date: [24 February 2023 12:44 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/39 "2023-02-24T12:44:12Z")
thank you very much Professor Johaness[.](https://hellodear.in/)
[.](https://teatv.ltd/)
---
### Author:  [@swasss](https://forum.dynare.org/u/swasss)
#### Post date: [2 March 2023 12:13 UTC](https://forum.dynare.org/t/erreur-de-compilation/21810/40 "2023-03-02T12:13:48Z")
good evening professor
I have tried but I still can’t do it. Please try to complete my git if you don’t mind of course.
thank you very much for your attention
[base DSGE.xlsx](https://forum.dynare.org/uploads/short-url/3xKhNdo9hqtJwoWrsWD3jNn1kJ5.xlsx) (12.0 KB)
[salim.mod](https://forum.dynare.org/uploads/short-url/im9IYvSvg4f6HhLv4OyDZsyk2aP.mod) (11.2 KB)
[Previous page](https://forum.dynare.org/t/erreur-de-compilation/21810.md?page=1)
[Next page](https://forum.dynare.org/t/erreur-de-compilation/21810.md?page=3)