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
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:
Page 1 has unknown type: 69Seeing 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