Thanks for the suggestion, the problem stems from the lengths in the Oracle table! It's a pretty weird behaviour though... Here is what I did: 1. Create a SAS data set in EG, and set the lengths of the data set before the SET clause, because the original length of the variabes are longer. For example display_nm is originally 1024 long: data user_permission_report; length display_nm $200; set source; run; 2 Create an Oracle data set by a single data step (sasoprsk is the oracle library): data sasoprsk.user_permission_report; set user_permission_report; run; 3. There is a view in a SAS EG library, which points to the oracle table. For example: proc sql; create view result.user_permission_report as select * from sasoprsk.user_permission_report; quit; Well, if I check the length in the three different tables, comes the magic: - in the 1st data set the length is 200 - in the 2nd, if I log in to Oracle and check the length of display_nm, it's VARCHAR2(800) - if I check the length in the SAS VIEW in EG by right click-> Properties-> Columns, it shows 1024! I wish I could to this with my bank account. 🙂 I guess it might be some kind of metadata collision, or what? Thank you for the help!
... View more