Help using Base SAS procedures

Specifying Schema

Reply
Contributor
Posts: 57

Specifying Schema

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.
Contributor
Posts: 57

Re: Specifying Schema

I found the answer for it too.

%let schema = AAA$BBBBBB;

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

quit;

Thanks,
Sandy.
Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 1 in conversation