topic Today or date function in New SAS User

Today or date function

Nini1 — Sat, 05 Sep 2020 23:30:46 GMT

Hi everyone,

I'm trying to create the variable that will contain month and day of today date.

I tried to create it with today() function and then take month and day from today function like this:

month (today()) and day(today()). The problem is that when I create a new column with today() function there is written some number and not just a date, therefore month() and day() functions do not work. Could you please help me to solve this problem?

Thank you in advance

Re: Today or date function

Tom — Sat, 05 Sep 2020 23:44:02 GMT

You need to show more what you did. A date IS just a number. The number of days since start of 1960. The MONTH() and DAY() functions do not care what format you are using to display the number, just that the number has the right value for a date.

2010  data test;
2011     today=date();
2012     month=month(today);
2013     day=day(today);
2014     put today=comma7. +1 today date9. +1 today yymmdd10. ;
2015     put month= day=;
2016  run;

today=22,163  05SEP2020 2020-09-05
month=9 day=5
NOTE: The data set WORK.TEST has 1 observations and 3 variables.

Re: Today or date function

PaigeMiller — Sun, 06 Sep 2020 11:00:05 GMT

This works:

data want;
    thisday=today();
    thismonth=month(thisday);
    thisyear=year(thisday);
run;

Since I did this in September 2020, I get the results thismonth=9 and thisyear=2020, which are correct.

Re: Today or date function

Nini1 — Mon, 07 Sep 2020 20:52:53 GMT

Thank you very much