Re: proc import without xslx formats

The problem is, I do receive reports on regular basis, it can`t be changed, and I want to automize the import process. I can switch into another procedure or data step or java object in sas but I can not change xlsx format.

Re: proc import without xslx formats

LibreOffice (OpenOffice) can be used to convert office files from the commandline, so that part is easy to automate. I can only repeat that the Excel file format is absolutely NOT SUITED for the transfer of tabular data for business intelligence. No control.

Searching around here on the SAS communities, you will find that statement repeated over and over again by people with experience.

Only about 1% of our jobs concern imports of data that initially came from Excel (or were at one place passed through Excel), but they cause about 10% of mainentance effort (searching and correcting errors). It's come so far that our auditors have explicitly forbidden the use of Excel for BI tasks. It may only be used as a data-entry tool for small data (like lookup tables). No Excel logic AT ALL.