I know that this guide was written a while ago, but I think this is the very relevant and updated information on the subject.. Therefore I am posting my question here. I was reading the paper "AT004: The Dark side of the transparent moon--Tips, Tricks and Traps of handling Oracle Data Using SAS" by Xinyu Ji. (NESUG 16)( https://www.lexjansen.com/nesug/nesug03/at/at004.pdf ) In the introduction section of the paper the author writes "there is a database account for the user 'samji'... the data resides in the path='nesug' and the public schema is 'sasusers' ". The author then creates a libname statement as follows. libname nesug ORACLE user=samji pw=.. path='nesug' schema=sasuser; I don't understand the word public schema. My understanding is that oracle has a public role and schema is the metadata of all the objects by a user and has the same name as the login. Thus in instant case for the user 'samji' schema will be 'samji'. Using the above libname the author runs proc contents on the library. I don't understand the term public schema 'sasusers'. Can you please enlighten on this ?
... View more