https://communities.sas.com/t5/ODS-and-Base-Reporting/SAS-and-Lotus-Notes/m-p/1651#M748 Anyone have experience with connecting to a Lotus Notes database and extracting data from the Lotus Notes database with SAS? I have been able to determine that I can connect to the Lotus Notes server, by pulling in data from a text file on the server. When I browse the server the Lotus Notes databases are not directly displayed, so it isn't as simple as selecting them from the list of available files. How do I locate and pull data from the Lotus Notes databases on the Lotus Notes server? Any help would be greatly appreciated. Tue, 24 Oct 2006 19:07:54 GMT Bryan_Walker 2006-10-24T19:07:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/SAS-and-Lotus-Notes/m-p/1651#M748 Anyone have experience with connecting to a Lotus Notes database and extracting data from the Lotus Notes database with SAS? I have been able to determine that I can connect to the Lotus Notes server, by pulling in data from a text file on the server. When I browse the server the Lotus Notes databases are not directly displayed, so it isn't as simple as selecting them from the list of available files. How do I locate and pull data from the Lotus Notes databases on the Lotus Notes server? Any help would be greatly appreciated. Tue, 24 Oct 2006 19:07:54 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/SAS-and-Lotus-Notes/m-p/1651#M748 Bryan_Walker 2006-10-24T19:07:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/SAS-and-Lotus-Notes/m-p/1652#M749 You can search the SAS documentation for the phrase:<BR /> "Lotus Notes" or "Notes Documents" and you will find a topic called "Introduction to Using Lotus Notes with SAS".<BR /> Down inside that topic is a link to a section called "Retrieving Information from Preexisting Notes Documents" which contains an example of the syntax you'd need. <BR /> <BR /> Or, you could contact Tech Support for more specific information. The first paragraph of this help topic says:<BR /> <B><BR /> "The SAS/ACCESS to ODBC pass-through engine enables you to retrieve information about existing Notes documents in a Notes database. Using ODBC to Retrieve Information from Preexisting Notes Documents shows an example of how to use the DATA step to retrieve information from the Business Card Request database."<BR /> </B><BR /> cynthia Tue, 24 Oct 2006 20:55:11 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/SAS-and-Lotus-Notes/m-p/1652#M749 Cynthia_sas 2006-10-24T20:55:11Z