12-08-2016 05:02 AM
A quick google of this reveals that BIFF12 is some sort of Excel file format, correct?
Regardless of that, most SAS file formats are proprietary closed ones. The exception being XPT. That being said it is easily possible to export to a variety of Office file formats, and many other file formats also from text, delimted, XML through databases etc.
You will need to be clearer on what you want to do.
12-08-2016 04:00 PM
I want to create a Binary File that mimics the .XLSB excel format. I know in SAS that there are many binary formats that are available and was wondering if there was one that matched the same as the BIFF12 format.
12-09-2016 04:31 AM
Nope, I think you might be confused about the file format question in general. XLSB is a proprietary - i.e. M$ own and keep secret - the file format for XLSB, it is compiled binary so you cannot see the underneath without some decompilation process. SAS binary files are SAS proprietary formats, i.e. they are compiled binary that SAS holds the rights and keeps secret. If the two had any simiarities it would be complete chance.
I would ask why the need for XLSB, as for me, I can never recommend using proprietary file formats. They are closed, and pretty difficult for anyone to use. True, they tend to be the smallest of the file types, but the lack of ope source/portability/user friendliness far outweighs any need for storage space. Why not export to XLSX if you really have to use Excel? You can export native XLSX from 9.4. Or there is the old proc export with xls, although you don't get any of the nice formatting etc.
A final alternative is to output a file and have a small section of VBA which opens the file and saves to XLSB.
But I really can't recommned the use of that file format.
12-09-2016 07:56 PM - edited 12-09-2016 07:58 PM
There is really not much reason to store Excel files in a binary .xlsb format and that's why Microsoft changed the default to .xlsx.
Not sure why you believe .xlsb is interchangeable. I'd say the opposite is true.