1 Reply Latest reply on Mar 7, 2016 6:17 AM by lindy.eberhart.0

    Problem with .sas files

    Kennen Gross

      I am reading in a 7.2 GB .sas7bdat file into Tableau 9.2.  I find that only 1/2 of the records gets imported into Tableau.  When I convert the data set to .csv and read in the data all of records get read into Tableau.  Has anyone else experienced this issue?  Is there a work around besides converting to .csv?

        • 1. Re: Problem with .sas files

          Hi Kennen,


          This sounds like an issue that was addressed in a maintenance release of Tableau Desktop. From our release notes page for 9.1.3:

          "In Tableau Desktop, when you connected to a SAS statistical file, the number of rows read from the file were sometimes truncated without any indication."


          • If you are not already on the latest build of Tableau Desktop (currently 9.2.5), I would suggest upgrading and testing the file again.
          • If you are already using the latest Tableau Desktop, I would suggest opening a support case either through your customer portal, or through the web form, and supplying our support team with the .sas file encountering the issue. If they can reproduce the issue in-house they should be able to help.


          I hope this helps!