community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx SAS output not recognised by SAS (base SAS 9.3)

Highlighted
Meteor

Hi there, 

 

I attempted to export data created in an Alteryx workflow as a SAS file (.sas7bdat) and then read the table into SAS via a LIBNAME statement. 

 

When doing this, I get the error message in SAS - Not a SAS file, file format  not recognised.

 

Is this expected and if not any suggestions of the best work around?

 

I do not want to export the data from Alteryx as a csv and upload it into SAS, as it is essentially an address datafile with approx 1000,000 rows with commas in the address field. 

 

Thanks

Alteryx
Alteryx

Hi @Citauma,

I would be interested in see the LIBNAME statement you're using to read the table.  I'm no SAS expert, I would like to have a better understand of the script you're using to read the .sas7bdat file.  I've haven't been able to reproduce this issue so far. 

Meteor

Hi Wayne

 

The statement was simply;

 

libname TESTLOC 'c:\........';

 

I must also say that the underlying data is a combination of numerical fields and long text strings (address data). When I create the SAS file with just numeric fields the file can be read into SAS.

 

When I do a combination of both numeric and character fields, SAS cannot recognise the data as a SAS dataset. I think it must have something to do with the existing issue known to Alteyx where the bit count increases by a multiple of 4 when creating SAS sas7dbat files.

Labels