@sabid wrote:
Hi. I am wanting to connect to our SAS server through an ODBC connect. I need access to data for a report in Excel. Can anyone tell me how to do this? Do I need a 32 or 64 bit driver? What port do I connect to?
Thanks!
Your need to explain more about what environment you have and what you want to do. A SAS server is NOT a database engine. It is a computer for running SAS code. So to connect to it using ODBC does not make much sense without more details about what in particular you are trying to do.
SAS datasets are files that live on your filesystem somewhere. Do you just need to read a SAS dataset? Can you just convert the dataset into the native format used by whatever software you are running? R and Python both have packages for reading SAS datasets. What type of SAS installation do you have? Are you running a SAS/Share server? That would look more like a traditional database that you could connect to. Are you running SAS workspace server? Just running SAS on your individual PC? Just running regular SAS (what they used to call BASE SAS or now call FOUNDATION SAS) on a multiuser operating system (like LINUX or IBM OS)?
Do you need to connect to a running SAS session that already has predefined librefs pointing to different data libraries and access some of those libraries. Or do you need to be able pass it the information about where to find the particular dataset(s) that you want to read?
... View more