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.
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: