Import Wizard in SASĀ® Enterprise GuideĀ® does not assign the TRAILSGNw. informat when needed


In SAS Enterprise Guide, when importing a text file that contains negative numeric data written with the minus sign after the digits, the incorrect informat is automatically assigned. The informat strips the numeric data of the minus sign and incorrectly reads it as positive.

The workaround is to explicitly assign the TRAILSGNw. informat during step three of the Import Wizard for any numeric data written with a trailing minus sign.