topic Re: Specifying Schema in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Specifying-Schema/m-p/38334#M9819 I found the answer for it too.<BR /> <BR /> %let schema = AAA$BBBBBB;<BR /> <BR /> proc sql noprint;<BR /> create table...................<BR /> ..................................<BR /> schema="&amp;schema"..............<BR /> ........................;<BR /> <BR /> quit;<BR /> <BR /> Thanks,<BR /> Sandy. Fri, 08 Jan 2010 16:23:17 GMT Sandhya 2010-01-08T16:23:17Z Specifying Schema https://communities.sas.com/t5/SAS-Procedures/Specifying-Schema/m-p/38333#M9818 Hi,<BR /> <BR /> I have a schema AAA$BBBBBB.<BR /> <BR /> If I connect to oracle and specify this schema name it returns with the error<BR /> <BR /> Invalid option name BBBBBB.<BR /> <BR /> How to address this issue.<BR /> <BR /> Thanks for helping,<BR /> Sandy. Fri, 08 Jan 2010 16:16:09 GMT https://communities.sas.com/t5/SAS-Procedures/Specifying-Schema/m-p/38333#M9818 Sandhya 2010-01-08T16:16:09Z Re: Specifying Schema https://communities.sas.com/t5/SAS-Procedures/Specifying-Schema/m-p/38334#M9819 I found the answer for it too.<BR /> <BR /> %let schema = AAA$BBBBBB;<BR /> <BR /> proc sql noprint;<BR /> create table...................<BR /> ..................................<BR /> schema="&amp;schema"..............<BR /> ........................;<BR /> <BR /> quit;<BR /> <BR /> Thanks,<BR /> Sandy. Fri, 08 Jan 2010 16:23:17 GMT https://communities.sas.com/t5/SAS-Procedures/Specifying-Schema/m-p/38334#M9819 Sandhya 2010-01-08T16:23:17Z