Hello, I want to append into Oracle a record that contains a numeric value from SAS. The value in SAS is defined as NUMERIC(8) with a format/informat of 19.2. It's an amount field, so it contains value like 120.14. In Oracle, the field is defined as NUMBER(19, 2). When I view the table in SAS, it says it's NUMERIC(8) with a format/informat of 21.2.   When I try the append, I have the following error: ERROR: ERROR: ERROR: ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed for this column. With the occurrence of the above ERROR, the error limit of 1 set by the ERRLIMIT= option has been reached. ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost). Total rows processed: 1 Rows failed : 1 ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).   I understand the error. It means I'm trying to pass a SAS value that is bigger than what Oracle would allow. I don't know how exactly to correct this in this case. Should I alter the Oracle table to allow bigger values? Should I change the SAS format? Any help would be appreciated. ... View more

Hello fellow SAS users,   We have users who execute SAS code in Enterprise Guide 5.1 to connect directly to databases, instead of using librairies and profiles setup for them in management console.   We would like to know which databases are used this way and which accounts are used to connect.   We do not have a repository of SAS source code, meaning that our users are free to store them wherever they want (even their PC). I can't just scan SAS code for the information.   We also have people who manually execute code that they didn't write. So asking users will not give us a complete answer to this question (although it could answer part of it).   I've looked online for a solution, but can't find anything. Anybody has a lead that could help me? FYI, our EG is on UNIX, if that matters. ... View more

Hi everyone, I'm attempting to export a SAS dataset in CSV format in UNIX. It hangs because the session doesn't have the -noterminal option. More infomation on the issue that I have : http://pages.stern.nyu.edu/~adesouza/sasfinphd/index/node15.html I do not have access to how my program is launched, so I can't simply add the -noterminal option. Is there any way I could circumvent the problem within my code? ... View more