Not getting Negitive balances in sas dataset

venugopal81 · Post by **venugopal81** » Wed Aug 03, 2005 3:16 am

I have changed current_bal field from varchar to numeric. Because I need to shown the negative balances in SAS.

But, some of the records are rejected and shown this warrning message.

Field
0: Import warning at record 21592:
"Current_Bal" has import error and no default value; data: {1 0 0 . 0 0 -}, at offset: 507

source: source.csv

Please advise me.

thanks
venu

roy · Post by **roy** » Thu Aug 18, 2005 12:57 am

Hi All,
Can anyone help with this?
(venugopal81 your more then welcome to submit a solution if you have 1 by now)
Thanks,

ArndW · Post by **ArndW** » Thu Aug 18, 2005 1:01 am

What kind of numeric did you redefine this column as? Does it have 2 decimal places? It is better to keep this as a text column and then apply a datatype conversion to decimal (StringToDecimal) inside the job. Basically the error is that "100.00-" cannot be parsed. Perhaps it is the trailing zero - which is why the StringToDecimal() function is better as you can specify the format accordingly.