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
Not getting Negitive balances in sas dataset
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 49
- Joined: Sat Mar 26, 2005 12:19 am
Hi All,
Can anyone help with this?
(venugopal81 your more then welcome to submit a solution if you have 1 by now)
Thanks,
Can anyone help with this?
(venugopal81 your more then welcome to submit a solution if you have 1 by now)
Thanks,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
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.