Transdata™ - Save Code

 

What is Transformation Code
Transdata is a code generator that generates standard SAS code to perform its data transformation. This is allows for the following advantages:

  • Users can reproduce the results in batch mode.
  • The program code can be used as a foundation template for more sophisticated customized transformation.
  • Testing and validation of the transformation can be performed by evaluating the log of the submitted code.

The SAS code is simple data step codes that are generated by the system to automate the process of applying transformations.

Where is Code Generated
SAS code generation can be requested either from the main "Transformation Data" screen or from the "Transformation Data Manager" screen. The difference being that the "Transformation Data" screen contains codes that transform only one dataset while the "Transformation Data Manager" screen can generate code for multiple transformation models at once.

The program can be stored anywhere on disk that the user has accessed. This program can then be executed as a stand-alone program outside of the Transdata system. It can be further modified to perform custom transformation. 

Once the "Save Code..." button is selected, the user decides where and what file name to save the file. The program can later be applied again. 

If multiple data models are selected on the transformation data manager screen, the file name is defaulted to be "trans_&model". This will produce multiple transformation programs one for each model. The name of the each program will have the name of the model replaced for the "&model". For example, if the model is named AE, the program will be "trans_ae.sas".

Editing Transformation Code
All the saved programs are listed in the saved program list within the "Transformation Data Manager" screen. You can select the program one at a time and view or edit the program by clicking on the Edit Program button.

It is optional to have your program viewable by other team members or have it only viewed by your self. This is accomplished by selecting the share public or private radio buttons. The programs will still be saved on disk but it will only hide for private from the list of programs listed in Transdata.

 
    Transdata - ETL CDISC Software,  Meta-Xceed Inc.© 2009
Bookmark and Share