Skip to content

SAS DI to Prophecy Conversion Nuances

This section describes nuances of converting from SAS DI to Prophecy.

Parameters of Custom Transformations

This section describes the translation of parameters from SAS DI custom transformations into properties of a Prophecy Custom Gem.

Text values

Single Values are translated as is:

  • "text_value" -> "text_value"
  • "col1 col2" -> "col1 col2"

Multiple Values are translated as a single string with values separated by a comma:

  • ["col1", "col2"] -> "col1, col2"

Numeric values

Single Values are translated as a string:

  • 1 -> "1"
  • 1.5 -> "1.5"

Multiple Values are translated as a single string with values separated by a comma:

  • [1, 2] -> "1, 2"
  • [1.2, 2.5] -> "1.2, 2.5"

Date values

SAS DI metadata stores date values as strings in two formats:

  • A formatted date string, such as "2022-05-02T00:00:00Z"
  • A special string for calculated dates, such as "Y0Y", "Q-1Q"

The translation process for date values is the same as that for text values.

Boolean values

There are two possible representations of boolean values in SAS DI metadata:

  • "True"/"TRUE" and "False"/"FALSE" strings
  • "Yes"/"YES" and "No"/"NO" strings

The translation process for boolean values is the same as that for text values.

Null or Empty values

Null or empty values are translated as null.

Special values

SAS DI prompts allow for the selection of the following special values for parameters:

  • All value
  • Missing value

The process for translating special values is as follows:

  • All value -> "__ALL__"
  • Missing value -> "__MISSING__"