|
Export and import transformation models to Excel spreadsheets %eximport
(modlib = library for models,
output = output Excel spreadsheet);
| Where |
Is
Type... |
And
represents... |
| modlib |
C |
SAS library name containing the models stored
as SAS datasets. This is specified with a two level name in the
format:
LIBRARY.DATSET
In the event that only the library is specified, all the models in
that library will be selected for import/export. |
| output |
C (optional) |
Output Excel spreadsheet file name including full
path. If none is
specified, the default name will be the model name with the XLS file extension
which is saved to the current folder location such as: AE.XLS.
It is recommended that a full path is specified with the Excel
filename since each model will be created in the same file as a
separate workbook shown as a tab in Excel. |
Details
This tool generates an Excel file which
contains the transformation specification stored in Transdata. It
can then import the same Excel file back into the existing model updating
it with values in the spreadsheet. This is equivalent to
clicking on the "Export" or "Import" buttons on the
"Edit Transformation Model" screen. The difference is that the user can
perform many import/exports at once with greater efficiency by simply
specifying the SAS library name to the models and the output path.
It is therefore recommended that only a libname be specified for the
MODLIB parameter. The default automation of the macro will then
export/import for all the models within the library.
 |
A separate workbook displayed as a separate tab within Excel will be
created for each data model. |
Example %eximport (modlib = modlib,
output = c:\temp\transpec.xls);
%eximport (modlib = modlib._mod1,
output = c:\temp\transpsec.xls);
|
