i am using SAS8.2 and trying to connect to oracle.My server is on unix and just want to know what are the interfacinf files which are used and how the connection is established.
You're SAS version is so outdated that it's hard to remember.
You basically need SAS/Access to Oracle licensed and on the same machine a compatible Oracle client to connect to.
You should find more details for 8.2 here both under the Installation and Documentation
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Registration is open
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!