topic Establishing a variable with a date in SAS Procedures

Establishing a variable with a date

deleted_user — Wed, 10 Dec 2008 16:35:10 GMT

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.

Re: Establishing a variable with a date

Doc_Duke — Wed, 10 Dec 2008 22:35:13 GMT

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.

Re: Establishing a variable with a date

deleted_user — Wed, 10 Dec 2008 22:41:02 GMT

Thanks.