BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Mushy
Quartz | Level 8

Hello,

 

Is there a way to import and export xlsm(macro enables) workbooks without the pc server?

 

Thanks,

Mushy

1 ACCEPTED SOLUTION
5 REPLIES 5
Sajid01
Meteorite | Level 14

Hello @Mushy 
If the intention of the import is to get data, then disable the macros and save it as xlsx.
Then it should be possible to get the data into SAS.

SASKiwi
PROC Star

If your SAS installation runs on Windows then the EXCEL engine (which uses MS Office components) should be able to read XLSM workbooks. This won't work for non-Windows SAS as the EXCEL engine isn't available.

Reeza
Super User
I haven't tested this in a while, but I would try writing to an XLSM file using the LIBNAME XLSX and see what happens.

Ultimately it depends on what exactly you're trying to accomplish here.
Ksharp
Super User
You could import xlsm file by
proc import + dbms=xlsx or excel
But You are unable to export xlsm file I guess.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1147 views
  • 5 likes
  • 6 in conversation