My PC was upgraded (in place upgrade) from windows 7 to windows 10 and office 10 to office 365 (2016). I did not reinstall SAS.
The code that worked before the upgrade is:
PROC IMPORT OUT= WORK.bigfixraw
DATAFILE= "C:\Users\cyndie\Documents\ProjectsLocal\bigfix\bigfix.xlsx"
DBMS=XLXS REPLACE;
RANGE="oct3$";
run;
Now I get the following error:
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
ERROR: Error in the LIBNAME statement.
After uninstalled and reinstalling the PC SAS FIle server did not correct the probrlem, I uninstalled and reinstalled SAS. SAS access is working properly. The windows and office upgrades were done in place and I would not be at all surprised if there there is something in the SAS install process that detects the OS or Office version and broke when office was upgraded.
I only used the import function as a troubleshooting tool--generally I use code and modify it as needed. I starting using SAS Access back in the dinasour age so this issue was not a huge surprise to me.. I was just hoping I could get around doing a fresh install.
Thanks everyone for your contributions.
It looks like you need to uninstall your current SAS PC Files Server and download & install the Windows (32-Bit) version of the SAS PC Files Server to match your 32-Bit version of Office. Follow the directions on this page:
Thanks. I confirmed that Ihave the 32 bit SAS file server installed which matches the 32 bit office. And SAS with excel prior to the upgrades when the OS was 64 bit, SAS was 64 bit, and Office was 32 bit. To be on the safe side al unintalled and reinstalled the PC SAS 32 bit file server. There was no change.
Until get this worked out I will use ,csv format
You may want to go one step further if you are going to be reading multiple files with similar data and save the data step created by proc import an possibly modify it by changing variable names, adding variable labels, making informats for character variables larger if likely to change. Then modify that program to point to new input files and change the output data set name.
This way all of your variables will remain as you specify. Proc import guesses as to variable type and length and may change characteristics when guessing for a different file.
After uninstalled and reinstalling the PC SAS FIle server did not correct the probrlem, I uninstalled and reinstalled SAS. SAS access is working properly. The windows and office upgrades were done in place and I would not be at all surprised if there there is something in the SAS install process that detects the OS or Office version and broke when office was upgraded.
I only used the import function as a troubleshooting tool--generally I use code and modify it as needed. I starting using SAS Access back in the dinasour age so this issue was not a huge surprise to me.. I was just hoping I could get around doing a fresh install.
Thanks everyone for your contributions.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!