META_VARIABLE_DIMENSION

Provide the correspondance table between EU-SILC variables and Eurobase equivalent dimensions.

Contents

A table named after the value &G_PING_VARIABLE_DIMENSION (e.g., META_VARIABLE_DIMENSION) shall be defined in the library named after the value &G_PING_LIBCFG (e.g., LIBCFG) so as to contain the correspondance table between EU-SILC variables (as used in the various databases: IDB/PDB/UDB) and Eurobase equivalent dimensions (as defined in the dictionary of dimensions), as well as their respective formats (type, length).

In practice, the table looks like this:

variable	dimension	type	length
DB020	GEO	char	5
DB030	TIME	numeric	4
AGE	AGE	char	15
RB090	SEX	char	15
HT1	HHTYP	char	15
...	...	...	...

Creation and update

Consider an input CSV table called A.csv, with same structure as above, and stored in a directory named B. In order to create/update the SAS table A in library C, as described above, it is then enough to run:

%meta_variable_dimension(cds_var_dim=A, cfg=B, clib=C);

Note that, by default, the command %meta_variable_dimension; runs:

%meta_variable_dimension(cds_var_dim=&G_PING_VARIABLE_DIMENSION, 
                cfg=&G_PING_ESTIMATION/meta, 
                clib=&G_PING_LIBCFG);

Example

Generate the table META_VARIABLE_DIMENSION in the WORK directory:

%meta_variable_dimension(clib=WORK);

References

1. Eurobase online dictionary.
2. Mack, A. (2016): "Data Handling in EU-SILC".

See also

%meta_variablexindicator, %meta_indicator_contents.