This must mean that your names data has overlapping periods for a given permno. Hypothetical example . . . permno     cusip     comnam     year_bg     year_end 111111     12345     Joe Blow     1993          2012 111111     12346     Jim Blow     2012          2013 The years overlap and this is probably the cause of your excess records . . . Question: should there be overlapping years in your names data? ... View more

Just took another look at this and noticed that you also missing a closing parenthesis. As per my previous note, you may also need to add the SCHEMA= option. Try the following . . . . proc sql ;    connect to oracle(user=rrimal orapw=XXXXXX path=clrabc);    execute( merge into clrabc.TEST_DATA  A              USING (SELECT * FROM clrabc.tEST_DATA_TWO ) B             ON (A.ENCOUNTER= B.ENCOUNTER AND A.MEASURE=B.MEASURE )               WHEN MATCHED THEN     UPDATE SET A.VALUE = B.VALUE      WHEN NOT MATCHED THEN           INSERT (A.ENCOUNTER,A.MEASURE,A.VALUE)          VALUES   (B.ENCOUNTER,B.MEASURE,B.VALUE)     );    execute (commit) by oracle;    disconnect from oracle; quit; ... View more

Also, you may need to add the following statement before the quit statement; execute (commit) by oracle; ... View more

Try adding the SCHEMA= option and see if that works. ... View more

Have you taken a look at the SAS 9.3 Migration Guide? SAS(R) 9.3 Intelligence Platform: Migration Guide ... View more

You can control axis-specific characteristics (e.g. font sizes) via the AXIS statement. I'm at home, without access to EG, so I'm not sure how you access the AXIS statement in the EG dialog. You should be able to alter axis settings via the task dialog box. If you can't find it, you can always manually modify the task by inserting your own code. ... View more