FINDMISSINGDATA

 

Introduction

This command returns variables with missing values in the Work databank.

 

 

Syntax

FINDMISSINGDATA < period > period variables ;

 

period

(Optional). For instance "2010 2020" or "2010q1 2020q4". If inside the <> field, the period is local to the current statement, if outside the period will be changed globally. If no period is given, global time will be used.

variables

List of variable(s) to check.

 

If no list of variables is given, all variables in the Work databank will be investigated

 

 

Example

For instance, the command

 

FINDMISSINGDATA <2008 2010>;

 

looks for all variables with any missing values in the period 2008-2010. You may restrict it like this:

 

FINDMISSINGDATA <2008 2010> #vars;

 

where the list #vars contains the relevant variables you want to check. Gekko outputs a number of lists from the investigation: for instance the list #missingdata contains all variables with missing data in the Work databank, whereas the lists #missingdata_all, #missingdata_endo etc. are subsets of that list, and correspond to the Gekko-defined lists #all, #endo etc. (i.e., all model variables, all endogenous model variables, etc.).

 

You may use wild-card lists if preferable:

 

FINDMISSINGDATA <2008 2010> [fX*] [fYf*];

 

This will check all variables starting with 'fX' or 'fYf'.

 

If a period is not given, the global time setting is used.

 

 

Note

The command is convenient when developing new models or changing existing models.

 

 

Related

commands

DIFPRT, NDIFPRT, see also 'Utilities' --> 'Compare two databanks'.