BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12
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.
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1164 views
  • 0 likes
  • 2 in conversation