SAS MDY Function Example

What is it?

• Accepts 3 integers, the Month (1-12), Day(1-31) and Year (either 2 digit or 4 digit)
• Returns the number of days since the YEARCUTOFF system option
• Combined with another function can output the date in a variety of formats.

Syntax:

• MDY(mm,dd, yy);
• MDY(m,dd, yyyy);

SAS Coalesc:

 SAS Coalesc Example:

Data work.my_data_file;     Result_1 = MDY(11,27,83);     Result_2 = MDY(11,27,1983);     Result_3 = MDY(09,01,84);     Result_4 = put(Result_1, worddate.);     Result_5 = put(Result_1, date9.);     Result_6 = put(Result_1, date11.); Run;

What's happening in the script above?

• The MDY function calculates the number of days since the YEARCUTOFF= system option
• The put function converts the MDY result into a re-formated version of the date
• The format worddate outputs a fully text version of the date.
• The format date9. and date11. indicated the number of characters to be returned. However, there are many other date formats available [full listing to be added]

Coalescec Function In SAS Examples:

Variable	Input	Output	Description
Result_1	mdy(11,27,83)	8731	MDY output; 2 Digit Year
Result_2	mdy(11,27,83)	8731	MDY output; 4 Digit Year
Result_3	mdy(09,01,84)	9010	MDY output; 2 Digit Year
Result_4	mdy(11,27,1983)	November 27, 1983	Format; worddate.
Result_5	mdy(11,27,1983)	27NOV1983	Format; date9.
Result_6	mdy(11,27,1983)	27-NOV-1983	Format; date11.

See also; Put Function