Alteryx truncating time variable from SAS dataset

[oerdem19]

Hi,

I am having problem importing a SAS dataset.

My time_m variable(with miliseconds) can be seen in SAS viewer as:

However, when I import the dataset, I get:

I tried to convert to a text field by using select field but still I get the truncated values.

I exported it to a CSV file to see if the values are there or not, but I got truncated values again.

So, is there a way to import Time_M from sas7bdat file?

Thank you.

[Biswarun]

Alteryx DateTime does not support milliseconds, as of yet. But you ought be able to store it as a string - can you share a sample sas7bdat file with bare minimum columns (and rows)? Thanks.

[oerdem19]

Here is a sample data. It would be great if I can get TIME_M  as a string into Alteryx.

Thank you.

[Biswarun · Accepted solution]

You have chanced upon a bug and it is impossible to rectify it without looking at the code base. Meanwhile, here's an alternate approach using Python tool and Pandas. 

[oerdem19]

You are amazing sir.

Thank you.