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.

Datasets

Date Time

Data Investigation

Accepted answers

Biswarun

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.

Run.yxzp

All comments

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.

example1.zip

Biswarun

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.

Run.yxzp

oerdem19

You are amazing sir.

Thank you.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703