Thanks for your help. But i want this to executed in 32 bit version Office in 64 SAS bit server.
Sounds like you need to submit a support ticket and let SAS Support answer.
EJ
I had a similar problem when I installed 9.3 some time ago. a type of HP printer as my default printer caused the problem.
Hi, Not sure if your issue has been resolved. You may have compatibility issues meaning if SAS is 64 bit and the Office that you are running is 32 bit. I know in such a situation you normally receive "Class not registered" or Excel engine not found" messages.
Try checking the Excel version and if different from SAS version try Installing 64 bit Office 2010 to match your version of SAS .
Try the following links in the order given
http://www.office.com/office64setup
Or
The following links involve more steps using PC Server Files with Import Wizard
http://support.sas.com/kb/44197
Or
Iinstalling a SAS PC File server which provides a bridge between 32 bit Office and 64 bit SAS.
http://support.sas.com/kb/43802
Thanks,
dose not work in 64 bit
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.