NLS Formats Supported by FedSQL

National Language Support (NLS) is a set of features that enable a software product to function properly in every global market for which the product is targeted. The SAS System contains NLS features to ensure that SAS applications can be written so that they conform to local language conventions. Typically, software that is written in the English language works well for users who use both the English language and also data that is formatted using the conventions that are observed in the United States. However, without NLS, these products might not work well for users in other regions of the world. NLS in SAS enables regions such as Asia and Europe to process data successfully in their native languages and environments. The FedSQL language supports the following NLS formats. For more information, see SAS National Language Support (NLS): Reference Guide.
Category
Language Element
Description
Date and Time
NLDATEw.
Converts a SAS date value to the date value of the specified locale, and then writes the date value as a date.
NLDATEMDw.
Converts the SAS date value to the date value of the specified locale, and then writes the value as the name of the month and the day of the month.
NLDATEMNw.
Converts a SAS date value to the date value of the specified locale, and then writes the value as the name of the month.
NLDATEWw.
Converts a SAS date value to the date value of the specified locale, and then writes the value as the date and the day of the week.
NLDATEWNw.
Converts the SAS date value to the date value of the specified locale, and then writes the date value as the day of the week.
NLDATEYMw.
Converts the SAS date value to the date value of the specified locale, and then writes the date value as the year and the name of the month.
NLDATEYQw.
Converts the SAS date value to the date value of the specified locale, and then writes the date value as the year and the quarter.
NLDATEYRw.
Converts the SAS date value to the date value of the specified locale, and then writes the date value as the year.
NLDATEYWw.
Converts the SAS date value to the date value of the specified locale, and then writes the date value as the year and the week.
NLDATMAPw.
Converts a SAS datetime value to the datetime value of the specified locale, and then writes the value as a datetime with a.m. or p.m.
NLDATMDTw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the name of the month, day of the month, and year.
NLDATMMDw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the name of the month and the day of the month.
NLDATMMNw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the name of the month.
NLDATMTMw.
Converts the time portion of a SAS datetime value to the time-of-day value of the specified locale, and then writes the value as a time of day.
NLDATMw.
Converts a SAS datetime value to the datetime value of the specified locale, and then writes the value as a datetime.
NLDATMWw.
Converts SAS datetime values to the locale sensitive datetime string as the day of the week and the datetime.
NLDATMWNw.
Converts a SAS datetime value to the datetime value of the specified locale, and then writes the value as the day of the week.
NLDATMYMw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the year and the name of the month.
NLDATMYQw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the year and the quarter of the year.
NLDATMYRw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the year.
NLDATMYWw.
Converts the SAS datetime value to the datetime value of the specified locale, and then writes the value as the year and the name of the week.
NLTIMAPw.
Converts a SAS time value to the time value of a specified locale, and then writes the value as a time value with a.m. or p.m. NLTIMAP also converts SAS date-time values.
NLTIMEw.
Converts a SAS time value to the time value of the specified locale, and then writes the value as a time value. NLTIME also converts SAS date-time values.
Numeric
NLBESTw.
Writes the best numerical notation based on the locale.
NLMNYw.d
Writes the monetary format of the local expression in the specified locale using local currency.
NLMNYIw.d
Writes the monetary format of the international expression in the specified locale.
NLNUMw.d
Writes the numeric format of the local expression in the specified locale.
NLNUMIw.d
Writes the numeric format of the international expression in the specified locale.
NLPCTw.d
Writes percentage data of the local expression in the specified locale.
NLPCTIw.d
Writes percentage data of the international expression in the specified locale.
NLPCTNw.d
Produces percentages, using a minus sign for negative values.
NLPCTPw.d
Writes locale-specific numeric values as percentages. Writes locale-specific numeric values as percentages.
NLPVALUEw.d
Writes p-values of the local expression in the specified locale.
NLSTRMONw.d
Writes the month name in the specified locale.
NLSTRQTRw.d
Writes a numeric value as the quarter-of-the-year in the specified locale.
NLSTRWKw.d
Writes a numeric value as the day-of-the-week in the specified locale.