topic Re: How find first date of month whenever i run that code . in SAS Programming

How find first date of month whenever i run that code .

Badshaah — Fri, 16 Dec 2016 10:43:22 GMT

Need to find first date in month ..where as i don't have any date variable in table it's just take date value from system.

Reeza — Fri, 16 Dec 2016 11:11:43 GMT

First = intnx('month', date(), 0,'b');

RW9 — Fri, 16 Dec 2016 11:20:01 GMT

Um, the first date in any month is the 1st? So:

data want;
  first_day_in_month=mdy(month(today(),1,year(today());
run;

Badshaah — Fri, 16 Dec 2016 12:04:10 GMT

Thanks Mate !!!