Data Model > Available DSCs > SAS DSC > Properties and settings used by SAS DSC
 
Properties and settings used by SAS DSC
Properties and settings allow you to control and customize the creation of the SAS data file. You specify properties and settings by using either or both of the following methods:
▪By adding custom properties to the MDM document that will be used to define the output data.
▪By including custom connection properties in the connection string for the SAS DSC.
If a property is specified by using more that one method, a connection string setting will override a custom property setting in the MDM document. Not all methods can be used for all properties—the entry for each property in the table below tells you which methods can be used.
Custom properties in the MDM document
MDM custom properties that can be used by the SAS DSC should be created in the SAS user context. However, the SAS DSC will attempt to read a custom property value from the Analysis user context if the property has not been set in the SAS user context.
Custom connection properties
You can specify custom connection properties by adding the MR Init Custom or MR Custom connection property to the connection string for the SAS DSC.
Format
MR [Init] Custom =
<property name>
 =
<value> (;
<property name>
=
<value>)*"
Example
MR Init Custom = "DecimalPlaces = 4; AliasCutFactor = 0.4"
Use the MR Init Custom property when you connect using the OLD DB Provider, for example, in a data management (.dms) script. If you are passing connection properties to an SAS DSC object that you have created programmatically, use the MR Custom property.
For a list of all the standard connection properties that are available to the SAS DSC, see Connection properties.
Properties and settings
Property
Description
Where this property can be set
AliasCutFactor
Double value to use for the CutFactor property on the Alias Map component's GeneratorConfiguration object. Valid values are in the range 0.0 to 1.0. The default is 0.5.
In an MDM document, on the document object.
In the connection string.
AllowOverwrite
Long value that specifies whether a new SAS data file can be created if a file of the given name already exists. Any non-zero value enables overwriting the existing file. The default is 0, which means that an error will occur if a file of the given name already exists.
See also the MR Init Overwrite connection property: see Connection properties.
In an MDM document, on the document object.
In the connection string.
BooleanFalse
Long value to write to the corresponding SAS variable when the response to the MDM variable is False. The default is 0.
In an MDM document, on a boolean variable.
In the connection string.
BooleanTrue
Long value to write to the corresponding SAS variable when the response to the MDM variable is True. The default is 1.
In an MDM document, on a boolean variable.
In the connection string.
DecimalPlaces
Long value that specifies the number of decimal places in the SAS format for the corresponding SAS variable.
In an MDM document, on a double variable.
DefTextVarSize
Long value that specifies the width in the SAS format for SAS character variables. The default is taken from the MDM EffectiveMaxValue property.
In an MDM document, on the document object.
In the connection string.In an MDM document, on the document object.
In the connection string.
DichotomyLabelNo
Character string to use for the DichotomyNo value in the SAS format for SAS variables in multiple dichotomy sets. For example, Nej or -. Not sensitive to the current language. The default is "No".
In an MDM document, on the document object.
In the connection string.
DichotomyLabelYes
Character string to use for the DichotomyYes value in the SAS format for SAS variables in multiple dichotomy sets. For example, Ja or X. Not sensitive to the current language. The default is "Yes".
In an MDM document, on the document object.
In the connection string.
DichotomyNo
Long value to write to a SAS variable in a multiple dichotomy set to indicate that the corresponding MDM category was not included in the response. The default is one less than the value of DichotomyYes.
In an MDM document, on the document object.
In the connection string.
 
DichotomyYes
Long value to write to a SAS variable in a multiple dichotomy set to indicate that the corresponding MDM category was included in the response. The default is 1.
In an MDM document, on the document object.
In the connection string.
ExportFactors
Boolean value specifying whether the value of the MDM category's Factor property, if set, should be written to the corresponding SAS variable. The default is False. ExportFactors will be overridden if the MDM category has the flUser flag set (see Missing values for more information). Note that ExportFactors does not apply to SAS variables in multiple dichotomy sets.
In an MDM document, on the document object.
In the connection string.
ProperSASFormat
Long value to specify the SAS data set version when exporting. The default value is 9.
In the connection string.
Width
Long value that specifies the width in the SAS format for the corresponding SAS variable. The default depends on the type of variable.
In an MDM document, on a long or double variable.
See also
SAS DSC