Skip to content

Error reading SAS files #15

Description

@petersonjr

Hello,

thank you for this useful project.
I am using Apache Metamodel and Metamodel Extras to get SAS tables metadata.
I am facing errors while reading some sas tables, which are files with the sas7bdat format.
I attached a file that contains a few tables to help me explain this issue better: sas_tables.zip.
Below, I summarized the result of reading each table attached with metamodel extras:

  • charset_cyrillic_and_more.sas7bdat: Example table that comes with SAS distribution. Table is read correctly
  • mammals.sas7bdat: Example table that comes with SAS distribution. Table is read correctly
  • pizza.sas7bdat: Example table that comes with SAS distribution. Table is read correctly
  • tabelasas_14mb.sas7bdat: Table created with SAS software. The table cant't be read, exits with the error msg: Page 1 has unknown type: 69
  • tabelasas400.sas7bdat: Table created with SAS software. Table is read but metamodel extras identifies no columns. I supose this happens because the file has only one page.

Seeing the examples above, we see that the example tables that comes with SAS distribution are read correctly. On the other hand, none of the tables created with our SAS distribution can be read. The error generally occurs while reading the second page of the file. In small files, only the first page is read, and this page is always identified as being of the 0 type, which means that metamodel extras is unable to identify table columns.

I suspect that somehow the tables which can't be read aren't in conformity with the binary format that metamodel extras expects.

Would you please help with this issue?

Thank you,

Péterson

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions