topic date format in data _null_ in SAS Programming

date format in data _null_

dht115 — Wed, 05 Jan 2022 21:30:40 GMT

How to obtain today's date in YYYY Month (ex. 2022 January) format?

%let today = %sysfunc(today());
%put &today;

Re: date format in data _null_

yabwon — Wed, 05 Jan 2022 21:44:55 GMT

Like that:

%let today = %sysfunc(today(),year4.) %sysfunc(today(),monname20.-L);
%put &today;

Re: date format in data _null_

yabwon — Wed, 05 Jan 2022 21:47:30 GMT

Or with proc format:

proc format;
 picture yearmonth (default=32)
  other='%Y %B' (datatype=date);
run;

%let today = %sysfunc(today(),yearmonth.);
%put &today;

Bart

Re: date format in data _null_

Reeza — Wed, 05 Jan 2022 21:53:13 GMT

SYSFUNC() has a second parameter that automatically applies a format, but there's no predefined SAS format for the display you're using. So you need to either combine two or roll your own, as Yabwon has demonstrated.