All,
We use a large number of excel files provided by vendors that include their respective signature as shown below. I was wondering if their is a way of getting that information out of the xlsx file.
Thanks.
To complete @Reeza 's reply, 2 methods::
1- Read the xlsx file as a zip file and read the xml files inside, see https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in...
2- Write a vbs script that reads the xlsx file and run it from SAS
To complete @Reeza 's reply, 2 methods::
1- Read the xlsx file as a zip file and read the xml files inside, see https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in...
2- Write a vbs script that reads the xlsx file and run it from SAS
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.