Informats Listed by Product

Base SAS

A B C D E F H I J K L M N O P Q R S T U V W Y Z

Name
Syntax and Description
ANYDTDTEw.
Reads and extracts the date value from various date, time, and datetime forms.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
ANYDTDTMw.
Reads and extracts datetime values from various date, time, and datetime forms.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
ANYDTTMEw.
Reads and extracts time values from various date, time, and datetime forms.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$ASCIIw.
Converts ASCII character data to native format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601CIw.d
Reads an IBM date and time value that includes a century marker, in the form cyymmddhhmmss<fff>.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601DAw.
Reads date values that are specified using the ISO 8601 base notation yyyymmdd.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601DJw.d
Reads a Java date and time value that is in the form yyyymmddhhmmss<ffffff>.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601DNw.
Reads date values that are specified using the ISO 8601 basic notation yyyymmdd and returns SAS datetime values where the time portion of the value is 000000.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601DTw.d
Reads datetime values that are specified using the ISO 8601 basic notation yyyymmddThhmmss<ffffff>.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601DXw.
Adjusts a Coordinated Universal Time (UTC) datetime value to the user’s local date and time. Then, reads the local date and time by using the ISO 8601 datetime and time zone basic notation yyyymmddThhmmss+|-hhmm
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601DZw.d
Reads Coordinated Universal Time (UTC) datetime values that are specified using the ISO 8601 datetime basic notation yyyymmddThhmmss+|–hhmm or yyyymmddThhmmss<ffffff>Z.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601LXw.d
Reads datetime values as local time by appending a time zone offset difference between the local time and UTC, using the ISO 8601 basic notation yyyymmddThhmmss+|–hhmm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601TMw.d
Reads time values that are specified using the ISO 8601 basic notation hhmmss<ffffff>.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601TXw.
Adjusts a Coordinated Universal Time (UTC) value to the user’s local time. Then, reads the local time by using the ISO 8601 basic time notation hhmmss+|–hhmm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
B8601TZw.d
Reads time values that are specified using the ISO 8601 basic time notation hhmmss<ffff>+|–hhmm or hhmmss<ffffff>Z.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$BASE64Xw.
Converts ASCII text to character data by using Base 64 encoding.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$BINARYw.
Converts binary data to character data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
BINARYw.d
Converts integer (fixed-point) or real (floating-point) binary values to integers.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
BITSw.d
Extracts bits.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
BZw.d
Converts blanks to 0s.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$CBw.
Reads standard character data from column-binary files.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
CBw.d
Reads standard numeric values from column-binary files.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$CHARw.
Reads character data with blanks.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$CHARZBw.
Converts binary 0s to blanks.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
COMMAw.d
Removes embedded characters.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
COMMAXw.d
Removes embedded periods, blanks, dollar signs, percent signs, hyphens, and close parentheses from the input data. An open parenthesis at the beginning of a field is converted to a minus sign. The COMMAX informat reverses the roles of the decimal point and the comma.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$CPTDWw.
Reads a character string that is in Hebrew DOS (cp862) encoding, and then converts the character string to Windows (cp1255) encoding.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$CPTWDw.
Reads a character string that is in Windows (cp1255) encoding, and then converts the character string to Hebrew DOS (cp862) encoding.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
DATETIMEw.
Reads datetime values in the form ddmmmyy hh:mm:ss.ss or ddmmmyyyy hh:mm:ss.ss.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
DATEw.
Reads date values in the form ddmmmyy or ddmmmyyyy.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
DDMMYYw.
Reads date values in the form ddmmyy<yy> or dd-mm-yy<yy>, where a special character such as a hyphen (-), period (.), or slash (/) separates the day, month, and year. The year can be either two or four digits.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601DAw.
Reads date values that are specified using the ISO 8601 extended notation yyyy-mm-dd.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601DNw.
Reads date values that are specified using the ISO 8601 extended notation yyyy-mm-dd and returns SAS datetime values where the time portion of the value is 000000.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601DTw.d
Reads datetime values that are specified using the ISO 8601 extended notation yyyy-mm-ddThh:mm:ss.<ffffff>.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601DXw.
Adjusts a Coordinated Universal Time (UTC) datetime value to the user’s local date and time. Then, reads the local date and time by using the ISO 8601 datetime and time zone extended notation yyyy-mm-ddThh:mm:ss+|–hh:mm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601DZw.d
Reads Coordinated Universal Time (UTC) datetime values that are specified using the ISO 8601 datetime extended notation yyyy-mm-ddThh:mm:ss+|–hh:mm.<fffff> or yyyy-mm-ddThh:mm:ss.<fffff>Z.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601LXw.
Reads datetime values as local time by appending a time zone offset difference between the local time and UTC, using the ISO 8601 extended notation yyyy-mm-ddThh:mm:ss+|–hh:mm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601LZw.d
Reads Coordinated Universal Time (UTC) values that are specified using the ISO 8601 extended notation hh:mm:ss+|–hh:mm.<fffff> or hh:mm:ss.<fffff>Z and converts the values to the local time.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601TMw.d
Reads time values that are specified using the ISO 8601 extended notation hh:mm:ss.<ffffff>.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601TXw.
Adjusts a Coordinated Universal Time (UTC) value to the user’s local time. Then, reads the local time by using the ISO 8601 extended time notation hh:mm:ss+|–hh:mm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
E8601TZw.d
Reads time values that are specified using the ISO 8601 extended time notation hh:mm:ss+|–hh:mm.<ffffff> or hh:mm:ssZ.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$EBCDICw.
Converts EBCDIC character data to native format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
EUROw.d
Reads numeric values, removes embedded characters in European currency, and reverses the comma and decimal point.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
EUROXw.d
Reads numeric values and removes embedded characters in European currency.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
FLOATw.d
Reads a native single-precision, floating-point value and divides it by 10 raised to the dth power.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$HEXw.
Converts hexadecimal data to character data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
HEXw.
Converts hexadecimal positive binary values to either integer (fixed-point) or real (floating-point) binary values.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
HHMMSSw.
Reads hours, minutes, and seconds in the form hh:mm:ss or hhmmss.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
IBRw.d
Reads integer binary (fixed-point) values in Intel and DEC formats.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
IBw.d
Reads native integer binary (fixed-point) values, including negative values.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
IEEEw.d
Reads an IEEE floating-point value and divides it by 10 raised to the dth power.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
JNENGOw.
Reads Japanese kanji date values in the form yymmdd.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
JULIANw.
Reads Julian dates in the form yyddd or yyyyddd.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$KANJIw.
Removes shift code data from DBCS data.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$KANJIXw.
Adds shift-code data to DBCS data.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$LOGVSRw.
Reads a character string that is in right-to-left logical order, and then converts the character string to visual order.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$LOGVSw.
Reads a character string that is in left-to-right logical order, and then converts the character string to visual order.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
MDYAMPMw.d
Reads datetime values in the form mm-dd-yy<yy> hh:mm:ss.ss AM|PM, where a special character such as a hyphen (-), period (.), slash (/), or colon (:) separates the month, day, and year. The year can be either two or four digits.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
MINGUOw.
Reads dates in Taiwanese format.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
MMDDYYw.
Reads date values in the form mmddyy or mmddyyyy.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
MONYYw.
Reads month and year date values in the form mmmyy or mmmyyyy.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
MSECw.
Reads TIME MIC values.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$N8601Bw.d
Reads complete, truncated, and omitted forms of ISO 8601 duration, datetime, and interval values that are specified in either the basic or extended notation.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$N8601Ew.d
Reads ISO 8601 duration, datetime, and interval values that are specified in the extended notation.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
NENGOw.
Reads Japanese date values in the form eyymmdd.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLDATEw.
Reads the date value as the local SAS date value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLDATEWw.
Reads the date value as a local SAS date and the day of the week that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLDATMAPw.
Reads the date value as a local SAS datetime with either a.m. or p.m. that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLDATMw.
Reads a datetime value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLDATMWw
Reads the date value as a local SAS day of the week and datetime that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIAEDw.d
Reads the monetary format of the international expression for the United Arab Emirates.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIAUDw.d
Reads the monetary format of the international expression for Australia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIBGNw.d
Reads the monetary format of the international expression for Bulgaria.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIBRLw.d
Reads the monetary format of the international expression for Brazil.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNICADw.d
Reads the monetary format of the international expression for Canada.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNICHFw.d
Reads the monetary format of the international expression for Liechtenstein and Switzerland.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNICNYw.d
Reads the monetary format of the international expression for China.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNICZKw.d
Reads the monetary format of the international expression for Czechia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIDKKw.d
Reads the monetary format of the international expression for Denmark, Faroe Island, and Greenland.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIEEKw.d
Reads the monetary format of the international expression for Estonia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIEGPw.d
Reads the monetary format of the international expression for Egypt.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIEURw.d
Reads the monetary format of the international expression for Austria, Belgium, Cyprus, Estonia, Finland, France, Germany, Greece, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, the Netherlands, Portugal, Slovakia, Slovenia, and Spain.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIGBPw.d
Reads the monetary format of the international expression for the United Kingdom.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIHKDw.d
Reads the monetary format of the international expression for Hong Kong.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIHRKw.d
Reads the monetary format of the international expression for Croatia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIHUFw.d
Reads the monetary format of the international expression for Hungary.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIIDRw.d
Reads the monetary format of the international expression for Indonesia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIILSw.d
Reads the monetary format of the international expression for Israel.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIINRw.d
Reads the monetary format of the international expression for India.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIJPYw.d
Reads the monetary format of the international expression for Japan.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIKRWw.d
Reads the monetary format of the international expression for South Korea.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNILTLw.d
Reads the monetary format of the international expression for Lithuania.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNILVLw.d
Reads the monetary format of the international expression for Latvia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIMOPw.d
Reads the monetary format of the international expression for Macau.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIMXNw.d
Reads the monetary format of the international expression for Mexico.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIMYRw.d
Reads the monetary format of the international expression for Malaysia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNINOKw.d
Reads the monetary format of the international expression for Norway.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNINZDw.d
Reads the monetary format of the international expression for New Zealand.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIPLNw.d
Reads the monetary format of the international expression for Poland.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIRUBw.d
Reads the monetary format of the international expression for Russia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNISEKw.d
Reads the monetary format of the international expression for Sweden.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNISGDw.d
Reads the monetary format of the international expression for Singapore.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNITHBw.d
Reads the monetary format of the international expression for Thailand.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNITRYw.d
Reads the monetary format of the international expression for Turkey.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNITWDw.d
Reads the monetary format of the international expression for Taiwan.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIUSDw.d
Reads the monetary format of the international expression for Puerto Rico and the United States.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNIZARw.d
Reads the monetary format of the international expression for South Africa.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLAEDw.d
Reads the monetary format of the local expression for the United Arab Emirates.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLAUDw.d
Reads the monetary format of the local expression for Australia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLBGNw.d
Reads the monetary format of the local expression for Bulgaria.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLBRLw.d
Reads the monetary format of the local expression for Brazil.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLCADw.d
Reads the monetary format of the local expression for Canada.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLCHFw.d
Reads the monetary format of the local expression for Liechtenstein and Switzerland.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLCNYw.d
Reads the monetary format of the local expression for China.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLCZKw.d
Reads the monetary format of the local expression for Czechia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLDKKw.d
Reads the monetary format of the local expression for Denmark, the Faroe Island, and Greenland.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLEEKw.d
Reads the monetary format of the local expression for Estonia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLEGPw.d
Reads the monetary format of the local expression for Egypt.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLEURw.d
Reads the monetary format of the local expression for Austria, Belgium, Cyprus, Estonia, Finland, France, Germany, Greece, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, the Netherlands, Portugal, Slovakia, Slovenia, and Spain.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLGBPw.d
Reads the monetary format of the local expression for the United Kingdom.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLHKDw.d
Reads the monetary format of the local expression for Hong Kong.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLHRKw.d
Reads the monetary format of the local expression for Croatia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLHUFw.d
Reads the monetary format of the local expression for Hungary.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLIDRw.d
Reads the monetary format of the local expression for Indonesia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLILSw.d
Reads the monetary format of the local expression for Israel.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLINRw.d
Reads the monetary format of the local expression for India.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLJPYw.d
Reads the monetary format of the local expression for Japan.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLKRWw.d
Reads the monetary format of the local expression for South Korea.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLLTLw.d
Reads the monetary format of the local expression for Lithuania.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLLVLw.d
Reads the monetary format of the local expression for Latvia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLMOPw.d
Reads the monetary format of the local expression for Macau.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLMXNw.d
Reads the monetary format of the local expression for Mexico.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLMYRw.d
Reads the monetary format of the local expression for Malaysia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLNOKw.d
Reads the monetary format of the local expression for Norway.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLNZDw.d
Reads the monetary format of the local expression for New Zealand.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLPLNw.d
Reads the monetary format of the local expression for Poland.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLRUBw.d
Reads the monetary format of the local expression for Russia.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLSEKw.d
Reads the monetary format of the local expression for Sweden.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLSGDw.d
Reads the monetary format of the local expression for Singapore.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLTHBw.d
Reads the monetary format of the local expression for Thailand.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLTRYw.d
Reads the monetary format of the local expression for Turkey.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLTWDw.d
Reads the monetary format of the local expression for Taiwan.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLUSDw.d
Reads the monetary format of the local expression for Puerto Rico, and the United States.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNLZARw.d
Reads the monetary format of the local expression for South Africa.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNYIw.d
Reads monetary data as a numeric value for the international expression that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLMNYw.d
Reads monetary data for the local expression as a numeric value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLNUMIw.d
Reads numeric data for international expressions as a numeric value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLNUMw.d
Reads numeric data for local expressions as a numeric value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLPCTIw.d
Reads percentage data for international expressions as a numeric value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLPCTw.d
Reads percentage data for local expressions as a numeric value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLSTRMON
Reads the month name as a numeric value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLTIMAPw.
Reads the time value and uses a.m. and p.m. as the local SAS time value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NLTIMEw.
Reads the time value as the local SAS time value that is appropriate for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
NUMXw.d
Reads numeric values with a comma in place of the decimal point.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$OCTALw.
Converts octal data to character data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
OCTALw.d
Converts positive octal values to integers.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PDJULGw.
Reads packed Julian date values in the hexadecimal form yyyydddF for IBM.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PDJULIw.
Reads packed Julian dates in the hexadecimal format ccyydddF for IBM.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PDTIMEw.
Reads packed decimal time of SMF and RMF records.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PDw.d
Reads data that is stored in IBM packed decimal format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PERCENTw.d
Reads percentages as numeric values.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$PHEXw.
Converts packed hexadecimal data to character data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PIBRw.d
Reads positive integer binary (fixed-point) values in Intel and DEC formats.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PIBw.d
Reads positive integer binary (fixed-point) values.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PKw.d
Reads unsigned packed decimal data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
PUNCH.d
Reads whether a row of column-binary data is punched.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$QUOTEw.
Removes matching single and double quotation marks from character data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
RBw.d
Reads numeric data that is stored in real binary (floating-point) notation.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$REVERJw.
Reads character data from right to left and preserves blanks.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$REVERSw.
Reads character data from right to left, and then left aligns the text.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
RMFDURw.
Reads duration intervals of RMF records.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
RMFSTAMPw.
Reads time and date fields of RMF records.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
ROWw.d
Reads a column-binary field down a card column.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FFw.d
Reads EBCDIC numeric data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FIBUw.d
Reads unsigned integer binary (fixed-point) values in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FIBw.d
Reads integer binary (fixed-point) values, including negative values, in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FPDUw.d
Reads unsigned packed decimal data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FPDw.d
Reads packed data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FPIBw.d
Reads positive integer binary (fixed-point) values in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FRBw.d
Reads real binary (floating-point) data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FZBDw.d
Reads zoned decimal data in which 0s have been left blank.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FZDLw.d
Reads zoned decimal leading-sign data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FZDSw.d
Reads zoned decimal, separate leading-sign data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FZDTw.d
Reads zoned decimal, separate trailing-sign data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FZDUw.d
Reads unsigned zoned decimal data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
S370FZDw.d
Reads zoned decimal data in IBM mainframe format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
SHRSTAMPw.
Reads date and time values of SHR records.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
SMFSTAMPw.
Reads time and date values of SMF records.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
STIMERw.
Reads time values and determines whether the values are hours, minutes, or seconds; reads the output of the STIMER system option.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
TIMEw.
Reads hours, minutes, and seconds in the form hh:mm:ss.ss, where special characters such as the colon (:) or the period (.) are used to separate the hours, minutes, and seconds.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
TODSTAMPw.
Reads an 8-byte time-of-day stamp.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
TRAILSGNw.
Reads a trailing plus (+) or minus (–) sign.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
TUw.
Reads timer units.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$UCS2BEw.
Reads a character string that is in the encoding of the current SAS session and then converts the character string to big-endian, 16-bit, UCS2, Unicode encoding.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS2Bw.
Reads a character string that is encoded in big-endian, 16-bit, UCS2, Unicode encoding, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS2LEw.
Reads a character string that is in the encoding of the current SAS session and then converts the character string to little-endian, 16-bit, UCS2, Unicode encoding.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS2Lw.
Reads a character string that is encoded in little-endian, 16-bit, UCS2, Unicode encoding, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS2XEw.
Reads a character string that is in the encoding of the current SAS session and then converts the character string to 16-bit, UCS2, Unicode encoding.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS2Xw.
Reads a character string that is encoded in 16-bit, UCS2, Unicode encoding, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS4Bw.
Reads a character string that is encoded in big-endian, 32-bit, UCS4, Unicode encoding, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS4Lw.
Reads a character string that is encoded in little-endian, 32-bit, UCS4, Unicode encoding, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS4XEw.
Reads a character string that is in the encoding of the current SAS session, and then converts the character string to 32-bit, UCS4, Unicode encoding.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UCS4Xw.
Reads a character string that is encoded in 32-bit, UCS4, Unicode encoding, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UESCEw.
Reads a character string that is in the encoding of the current SAS session, and then converts the character string to UESC representation.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UESCw.
Reads a character string that is encoded in UESC representation, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UNCREw.
Reads a character string in the encoding of the current SAS session, and then converts the character string to NCR.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UNCRw.
Reads an NCR character string, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UPARENEw.
Reads a character string that is in the encoding of the current SAS session, and then converts the character string to UPAREN representation.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UPARENPw.
Reads a character string that is encoded in UPAREN representation, and then converts the character string to the encoding of the current SAS session, with national characters that remain in the encoding of the UPAREN representation.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UPARENw.
Reads a character string that is encoded in UPAREN representation, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UPCASEw.
Converts character data to uppercase.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$UTF8Xw.
Reads a character string that is encoded in UTF-8, and then converts the character string to the encoding of the current SAS session.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$UUIDw.
Converts a Universally Unique Identifier (UUID) to binary data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$VARYINGw. length-variable
Reads character data of varying length.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
VAXRBw.d
Reads real binary (floating-point) data in VMS format.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
VMSZNw.d
Reads VMS and MicroFocus COBOL zoned numeric data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
$VSLOGRw.
Reads a character string that is in visual order, and then converts the character string to right-to-left logical order.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$VSLOGw.
Reads a character string that is in visual order, and then converts the character string to left-to-right logical order.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
$w.
Reads standard character data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
w.d
Reads standard numeric data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
WEEKUw.
Reads a value in the form of a week number within the year and returns a SAS date value by using the U algorithm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
WEEKVw.
Reads a value in the form of a week number within a year and returns a SAS date value by using the V algorithm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
WEEKWw.
Reads a value in the form of a week number within the year and returns a SAS date value by using the W algorithm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
YENw.d
Removes embedded yen signs, commas, and decimal points.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
YMDDTTMw.d
Reads datetime values in the form <yy>yy-mm-dd hh:mm:ss.ss, where special characters such as a hyphen (-), period (.), slash (/), or colon (:) are used to separate the year, month, day, hour, minute, and seconds. The year can be either two or four digits.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
YYMMDDw.
Reads date values in the form yymmdd or yyyymmdd.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
YYMMNw.
Reads date values in the form yyyymm or yymm.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
YYQw.
Reads quarters of the year in the form yyQq or yyyyQq.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
ZDBw.d
Reads zoned decimal data in which zeros have been left blank.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
ZDVw.d.
Reads and validates zoned decimal data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
ZDw.d
Reads zoned decimal data.
Product: Base SAS
Document: SAS Formats and Informats for SAS Viya Workbench
Last updated: September 24, 2026