topic Re: The format could not be loaded in cloud analytic services in SAS Viya

The format could not be loaded in cloud analytic services

bheerschop — Mon, 15 Aug 2022 15:23:41 GMT

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

Re: The format could not be loaded in cloud analytic services

Tom — Mon, 15 Aug 2022 15:33:54 GMT

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?

Re: The format could not be loaded in cloud analytic services

SASKiwi — Mon, 15 Aug 2022 20:12:11 GMT

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.

Re: The format could not be loaded in cloud analytic services

bheerschop — Tue, 16 Aug 2022 07:53:35 GMT

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.

Re: The format could not be loaded in cloud analytic services

bheerschop — Thu, 18 Aug 2022 07:22:51 GMT

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.