14. Format not accepting >9 digits

[ThomasH]

Hi all,

got another problem here. I am working with DI Studio and just tested some min/max field format and informat values via direct input in DI Studio datasets.

It seems that for a column with format "14." (length 😎 I cannot enter values with >9 resp. >10 digits depending on the number I use.

E.g.

99999999999999 -> Not a valid integer value
999999999 -> works (9x 9)

11111111111111 -> not a valid integer value
1111111111 -> works (10x 1)

Trying it purely in SAS base works. Is this a DI studio issue?

Thanks and regards,
Thomas

[Cynthia_sas]

Hi:
I'd recommend that you contact Tech Support directly with this issue, they can replicate your DI Studio scenario and help you find a solution.
cynthia

[ThomasH]

FYI - found in DI Studio help.

Maximum Integer Value for a Field in SAS Data Integration Studio
The maximum value allowed for an integer entered into a field in SAS Data Integration Studio is 2,147,483,647.

Rgds,
Thomas

Note: This limit just applies to the GUI, with BASE code it works