Use a different compression scheme to make the file readable for Tableau

[KimLeBouton]

I have a user that has moved to Tableau Desktop 2020.1 and can no longer read a compressed SAS dataset.

The Tableau message is as follows:

Note: As of version 2020.1, Tableau no longer supports statistical files compressed with SASYZCR2. Use a different compression scheme to make the file readable for Tableau.

Has anyone found a workaround?  For the short-term, the SAS user removed the default compression, but that isn't a great long-term solution.

Thanks in advance for any information that you can provide.  The user prefers to Tableau tool for connection versus and ODBC/OLE/JDBC connection through a SAS/Access tool and SAS driver.

[Tom]

The message from Tablaau is a little cryptic for normal SAS users.  I think they are talking about BINARY compression option. 

Try creating the SAS datasets using the the COMPRESS=YES (alias COMPRESS=CHAR) option instead.

[ChrisNZ]

RDC compression (SASYZCR2) is called binary compression in SAS programs, and RLE compression (SASYZCRL) is called character compression in programs.

If Tableau stopped supporting RDC compression the question should be directed at them.

In the meantime try RLE compression as suggested: option compress=char;

[KimLeBouton]

Thank you for this clarification.

Compression=char was used and we still got the error message.

We will reach out to Tableau.

Kim