I am reading Oracle tables via Proc SQL in SAS version 9.1.3. I have successfully used SAS to read the Oracle tables for over 10 years. The past couple of months I will run the same program, back-to-back, and get a different number of observations as a result. I do not know if this is an Oracle database problem, or if perhaps my SAS version is unreliable or too old? I sometimes get values for a field that do not exist. For example: values for user_status should be 'Active - Promotion', 'Active - New Hire', and I will get values like 'motionActive - Pro' which is not a valid value for user_status. Has anyone encountered problems such as these? Thanks in advance!
... View more