The format could not be loaded in cloud analytic services

[bheerschop]

Hello,

I have loaded a base SAS table from a SAS 9.4 environment to a SAS Viya 2022.1 environment but I get the following error while trying to analyse the table:

This is not a user defined format so how do I enable this format in the SAS Viya environment?

Thanks!

Berry

[Tom]

Is it possible you are using an older version that does not have the format?

Did you try using the Dutch (or whichever language you want) specific version instead?

[bheerschop]

The version should include this format.

The format with the Dutch specific version does work correctly (NLDDFWKX15.).

I contacted SAS Technical Support for further assistance.

[SASKiwi]

This format is included in the Viya 2022.1 documentation. Sounds like a problem for SAS Tech Support if you haven't opened a track already.

[bheerschop · Accepted solution]

Feedback form SAS Technical Support:

It seems the EUR formats will not work in VIYA UI. 

This is what the backline mentions:

See documentation https://go.documentation.sas.com/doc/en/pgmsascdc/v_026/nlsref/n1ta9hosby6dq3n16s5wgc6908po.htm.

I would assume that explains why Data Explorer does not allow EURxxxxxx formats but works with Nlxxxxxxx formats. The programming environment allows more flexibilty, but the VIYA UI will follow best practices.