Set Default SAS Number Format

The default value in Oracle Life Sciences Data Hub for SAS number format is 8, which does not support precision.

To change the default value to BEST, change the value of this profile to Yes.

1. Log in. See How to Log In to Oracle Applications Profile Forms.
2. In the Profile field, enter LSH: Default SAS Number Format BEST.
3. Click Find.
4. In the Site column:
   • Select No to make the default SAS number format value equal to 8. This is the default value.
   • Select Yes to make the default SAS number format value equal to BEST, which supports precision in numbers and is the best value if you load files that do not have a SAS number format specified.

     Note:

     If you change this setting, running any existing Load Sets having target Table instances with Number columns that have the old default value of 8 will end with a warning if you load files that do not have a SAS number format specified. This is because the metadata comparison will show a difference between the source and target.
5. In the File menu, select Save and Proceed. The system displays a message that the transaction is complete.
6. Click OK. The transaction message pop-up disappears.
7. Click the X in the upper right corner of the System Profile Values window to close the window.