MDY Function

The MDY function converts MONTH, DAY, and YEAR values to a SAS date value. For example, MDY(10,19,1999) returns the SAS date value ’19OCT99’D.

Syntax:    MDY(month,day,year)

Arguments

month : specifies a numeric expression t…

Find Documentation for SAS Functions

A few weeks ago, I answered the question How do I find documentation for SAS Procedures? Earlier this week, another question was submitted by a site visitor. This time, the customer is looking for a list of SAS macros.

Q: I am trying to locate…

SAS EG: Filtering a dataset via prompt manager variable

Nobody who reads this blog is likely a SAS programmer. However, on the off chance this would be useful to someone who finds it via Google, I wanted to post. Currently, I am working on a project in SAS Enterprise Guide where I needed to allow the user to provide variable value(s) via prompt manager […]

SAS—your wish is my command

I love to teach SAS programming and in this blog, I hope to share best practices, tips, tricks and answer some frequently asked questions by our SAS users. I’m constantly learning more nuances of SAS and more programming languages like SQL. Why …