-
Notifications
You must be signed in to change notification settings - Fork 48
SDMX Connector for SAS
The SAS Connector for SDMX.
All the instructions that follow refer to linux, but they can be easily adapted to Windows installations.
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 R package
-
Download the SAS sources from the SAS project directory
-
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
-
Build the java library or download it from the R package
-
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
Calling the graphical SDMX helper:
%sdmxhelp;
Get data (and, optionally, metadata):
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