topic How and where to set the OPTION LOCALE= in SPD Server Loader in SAS DI? in SAS Programming

How and where to set the OPTION LOCALE= in SPD Server Loader in SAS DI?

damanaulakh88 — Fri, 07 Jun 2013 12:14:51 GMT

Hi,

I am stuck with the Language option and do not know the position in the settings or advanced options.This is the issue with SAS Clustering.

I am getting the TABLE:FLAGS error while running the cluster code.

I am working in SAS DI.

Can anybody help me on that ?

Thanks,

Daman

Re: How and where to set the OPTION LOCALE= in SPD Server Loader in SAS DI?

LinusH — Mon, 10 Jun 2013 10:14:53 GMT

SPD Server will inherit the locale and encoding of the connecting Base SAS session, so setting it using an options statement would work in most cases. In my mid, most sites would have this in the central config file, to avoid unwanted differences between tables created by different users/processes.

You might need to recreate all tables within the cluster to be sure that they all share the same encoding.