Hi All, I have recently convinced my organisation to get SAS after a very long back and forth argument. They have agreed to give me one desktop licence of analytic pro,I understand analytic pro is SAS EG. I want to be able to connect to our Micro-soft SQL server and be able to Query our database directly through SAS tool.As well as Excel and flat file if need be. What SAS/ACCESS would you recommend or is good for my organisation. Because I am the one driving this,I will have to set the SAS analytic pro up to ensure it does what I want it to do. I am a SAS user mainly base SAS, but I have not been involved in the administration side or configuration of this tool before, but it will be a very valuable experience for me. Therefore which of the following below is best for me and any code suggestion that optimise the performance of those listed below: SAS/ACCESS Interface to ODBC SAS/ACCESS Interface to Microsoft SQL Server for Windows and UNIX (this includes SAS Access/ODBC and an ODBC driver for MS SQL Server SAS/ACCESS to OLE D SAS Add-in for Microsoft Excel SAS/ACCESS Interface to PC Files Also any expert advice will be welcome,as i have to/Need to prove to my bosses that SAS is a good analytic and easy to use tool for the business Thanks
... View more