topic Re: Can we append Excel(.xslb) file into .sas7bdat in SAS Programming

Can we append Excel(.xslx) file into .sas7bdat

qwerty12 — Thu, 29 Dec 2022 09:37:36 GMT

Can we append Excel(.xlsx) file into .sas7bdat

Re: Can we append Excel(.xslb) file into .sas7bdat

Patrick — Thu, 29 Dec 2022 08:51:28 GMT

@qwerty12 wrote:

Can we append Excel(.xlsb) file into .sas7bdat

These are two totally different file formats from different vendors - so no, certainly not directly without conversion from the one to the other format.

If you can read your .xlsb data into a SAS table (.sas7bdat) then you can append this SAS table to an already existing SAS table IF they share the same columns.

Reading an Excel sheet directly into SAS also always has the issue that you can't fully control the resulting output table - column type and attributes. If you want to implement something repeatable then additional measure are required - and there have already been many Q&A in this forum around this topic.

Ideally use a .xlsx file and not .xlsb
https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-xlsb-SAS-EG-7-1-64-bits/td-p/351501

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/n0msy4hy1so0ren1acm90iijxn8j.htm

Re: Can we append Excel(.xslx) file into .sas7bdat

ErikLund_Jensen — Thu, 29 Dec 2022 18:29:20 GMT

Hi @qwerty12

You can do that with xlsx files, because the SAS XLSX engine lets you see an xlsx file as a library with the induvidual sheets as members. I don't think it works with xlsb-files.

But - as explained by @Patrick - it is two very different file systems, and you might run into all sorts of trouble with both variable names and sheet names depending on your validname settings and interpretation of variable content, so I don't think is is a good idea. It is better to get your data into SAS, so you can verify results, rename variables, apply formats etc, before you try to append the contents to an existing data set.