Cynthia, You Rock! ... View more

Adding ods_all_close; was part of it. I then needed to turn on "ods listing;"    I don't fully understand it, but those two lines (47 & 48 below) did it for me.         47 ods _all_ close; 48 ods listing; 49 50 51 filename graphout "&dir0\brs_m29.gif"; 52 goptions gsfname=graphout gsfmode=replace device=gif; 53 54 proc gplot data=freq03; 55 plot percent * yq = finalrating / grid ; 56 run; NOTE: 101 records written to \\sassrvr\shared\users\steve\BRS\brs_m29.gif 57 quit;             ... View more

You should review the requirements that SAS has to have to allow Oracle to do the work,if possible.  For example, if schema1 and schema2 are on the same oracle instance and are accessed with the same userid, then sas will pass the query to oracle to execute as long as there are no sas functions that it can't translate into oracle syntax.  Unfortunately, I believe that substr is one of those functions that while Oracle has an equivalent function, its use as criteria will cause SAS to bring data out of oracle prior to performing the join. If you use the pass-through, I believe oracle has some implicit conversion rules that would allow the comparison int_id=substr(string_id,1,5). ... View more