Hi, I'm trying to import an xlsm file into SAS and am operating on a Windows 10 machine. For some reason it's not working. Any suggestion are greatly appreciated. Thanks
What does "For some reason it's not working." mean?
Please let me know what you tried and what the results were.
For example, error messages printed in the SAS log window.
Also, it would be better if you have an xlsm file with sample data.
Is it possible to receive the data as a normal XLSX file instead? SAS will not have any use for any embedded Excel macros the spreadsheet might have it in anyway.
The biggest downside of XLSX was that you couldn’t store VBA macros. Well, that’s the biggest positive of XLSM. Anytime you try to save a VBA macros file in Excel, you will be prompted to use XLSM because it’s compatible with VBA macros.
proc import with dbms=xlsx should be able to read and excel with the xlsm extension. However you will need to have SAS/ACCESS Interface to PC Files
@podarum wrote:
The fix happened to be a combination between Windows bit size, Office bit size and SAS installed bit size... they all had to be a 64 bit. Once that was fixed, it worked. Thanks everyone.
Then mark your posting as the solution.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: