Help using Base SAS procedures

Establishing a variable with a date

Reply
N/A
Posts: 0

Establishing a variable with a date

Quick dumb question here.

I want to assign to a variable today's date minus 365 days. How do I do this? I'm sure it's quick and easy, but what I've done so far seems to take the literal value that I'm trying to assign; TODAY() - 365;. I want to be able to establish this dynamically and not have to hard code the date each time I run the program.

I need to pass this into a piece of PROC SQL code later in the program.

Thanx.
Trusted Advisor
Posts: 2,113

Re: Establishing a variable with a date

x = today() - 365;
FORMAT x date9.

will set "x" to one year ago today. In SQL, that is just

SELECT
(today() - 365) AS x

You can add the format too in SQL, the syntax is in the manual.
N/A
Posts: 0

Re: Establishing a variable with a date

Thanks.
Ask a Question
Discussion stats
  • 2 replies
  • 92 views
  • 0 likes
  • 2 in conversation