How to make proc report header automatically display current month?

ernie86 — Wed, 25 Jan 2017 16:52:21 GMT

proc report data=A out=B;
title j=left h=12pt bold "%sysfunc(month("&sysdate"d))";

I want the report header automatically shows the current month such as January, February, March.... However, my code is returning number that represent the current month. So the header is displaying 1 instead of January. Can someone please tell me how to make it spell out the month?

Re: How to make proc report header automatically display current month?

data_null__ — Wed, 25 Jan 2017 17:35:50 GMT

@ernie86 wrote:

proc report data=A out=B;
title j=left h=12pt bold "%sysfunc(month("&sysdate"d))";

I want the report header automatically shows the current month such as January, February, March.... However, my code is returning number that represent the current month. So the header is displaying 1 instead of January. Can someone please tell me how to make it spell out the month?

You need to "print" the value of sysdate using a format.

25         %put NOTE: **%sysfunc(putn("&sysdate"d,monname-l))**;
NOTE: **January  **

If you want to remove the blanks at the end of the string returned from PUTN you can use %UNQUOTE

25         %put NOTE: **%unquote(%sysfunc(putn("&sysdate"d,monname-l)))**;
NOTE: **January**

topic Re: How to make proc report header automatically display current month? in SAS Programming

How to make proc report header automatically display current month?

Re: How to make proc report header automatically display current month?