I'm sorry this is possibly a silly question, but I've always had IT people to set this up for me.
I'm trying to connect SAS to an ODBC server. I have both a user DSN and system DSN working.
I can access the tables in Oracle SQL Developer. However, and I don't know if this is relevant, but in the navigating pane to the left, where there is a sort of 'drop down file structure', the tables are located: server_name/other_users/libraries/table(s). As far as SAS code to access those tables, this is as far as I've gotten:
libname my_library odbc user=username password="password" datasrc=server_name;
This creates a library, but with no tables.
I don't know what other commands or info I am missing, but recognize many people used a schema and I do not know what that is. Can anyone please help?
Thanks in advance!