MDYAMPMw.d Informat
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
2 or 4 digits.
| Category: |
Date and Time |
| Alignment: |
Right |
| Requirement: |
A space must separate the date and the time. |
| Note: |
The default time period is AM. |
Syntax
Syntax Description
w
specifies the width
of the output field.
d
specifies the number
of digits to the right of the decimal point in the seconds value.
The digits to the right of the decimal point specify a fraction of
a second. This argument is optional.
Details
The MDYAMPMw.d format
reads SAS datetime values in the form
mm-
dd-
yy<
yy>
hh:
mm<:
ss<
.ss>> <AM | PM>:
mm
is an integer between
01 and 12 that represents the month.
dd
is an integer between
01 and 31 that represents the day of the month.
yy or yyyy
specifies a two-digit
or four-digit integer that represents the year.
hh
is an integer between
00 and 23 that represents hours.
mm
is an integer between
00 and 59 that represents minutes.
ss.ss
is the number of seconds
that range from 00–59 with the fraction of a second following
the decimal point.
Requirement: If a fraction of a second is specified, the decimal point can be
represented only by a period and is required.
AM | PM
specifies either the
time period 00:01–12:00 noon (AM) or the time period 12:01–12:00
midnight ( PM)
- or :
represents one of several
special characters, such as the slash (/), hyphen (-), colon (:),
or a blank character that can be used to separate date and time components.
Special characters can be used as separators between any date or
time component and between the date and the time.
Comparisons
The MDYAMPMw.d informat reads datetime values with optional
separators in the form mm-dd-yy<yy> hh:mm:ss.ss AM | PM, and requires a space between the date and the time.
The DATETIMEw.d informat reads datetime values with optional
separators in the form dd-mmm-yy<yy> hh:mm:ss.ss AM|PM, and the date and time can be separated by a special character.
The YMDDTTMw.d informat reads datetime values with required
separators in the form <yy>yy-mm-dd/hh:mm:ss.ss.
Example
input @1 dt mdyampm25.2.;