Specifying Schema

[Sandhya]

Hi,

I have a schema AAA$BBBBBB.

If I connect to oracle and specify this schema name it returns with the error

Invalid option name BBBBBB.

How to address this issue.

Thanks for helping,
Sandy.

[Sandhya]

I found the answer for it too.

%let schema = AAA$BBBBBB;

proc sql noprint;
create table...................
..................................
schema="&schema"..............
........................;

quit;

Thanks,
Sandy.