Skip to content

SDMX Connector for SAS

Jump to bottom
Attilio Mattiocco edited this page Aug 20, 2015 · 16 revisions

The SAS Connector for SDMX.

All the instructions that follow refer to linux, but they can be easily adapted to Windows installations.

How to build it

The only part of the connector that needs to be built is the Java library. Instructions can be found in the java section

NOTE: building the java library is not strictly necessary. A jar file, ready to be used, can be retrieved from the project lib subdirectory

How to install it

  1. Clone the repository or download a the full project in zip format and unpack it. Get the SAS files from the project SAS directory.

  2. The SDMX functions are standard SAS macros. They can be loaded manually every time you want to use them, or you can set up an autocall library. Some more info can be found in the SAS Documentation

  3. Build the java library or get it from the R project inst subdirectory

  4. The SDMX Java library needs to be added to the CLASSPATH that is configured in SAS. This can be either achieved by modifying the system CLASSPATH or by changing the SAS configuration. Some more info can be found in the SAS Documentation

  5. If necessary, override the default configuration by means of a custom configuration file. This is particularly necessary if you want to run the connector in an environment that connects to the internet by means of a proxy.

How to use it

Calling the graphical SDMX helper: sdmxHelp command. Just type:

%sdmxhelp;

Get data and metadata: gettimeseries command. This command can take the following parameters:

provider: the name of the data provider (mandatory)
tskey: the time series query (mandatory)
start: the start time of the data to be retrieved (optional)
end: the end time of the data to be retrieved (optional)
metadata: 0: data only, 1: data and metadata (optional)

Examples:

single time series, freq=A, CURRENCY=USD
%gettimeseries(provider="ECB", tsKey="EXR.A.USD.EUR.SP00.A");

multiple time series, FREQUENCY=A (annual), all currencies
%gettimeseries(provider="ECB", tsKey="EXR.A.*.EUR.SP00.A");

get data and metadata
%gettimeseries(provider="ECB", tsKey="EXR.A.*.EUR.SP00.A", metadata=1);

NOTE: data results will be stored to a sdmxdata dataset. If enabled, metadata results will be stored to sdmxmetadata

Clone this wiki locally