Cannot read SAS output files (.tab)

wale_ilori

I have a situation where the SAS output files in .tab format gave an error message in Alteryx when I try accessing the files using the input tool. Changing the file extension to .txt or .csv resolved this but not a convenient solution. Does anyone know why this is happening? Thanks.

RodL

.tab is the default extension for a MapInfo file, and it is one of the "native" file formats that Alteryx recognizes, so I'm guessing that it is expecting a MapInfo file.

Once you connect to the file in the "Connect a File..." configuration of the Input Data tool, try changing the "File Format" (option 2) in the configuration options. You should be able to choose .csv without having to change the actual file name.