DATA Step, Macro, Functions and more

How to make proc report header automatically display current month?

Reply
Occasional Contributor
Posts: 19

How to make proc report header automatically display current month?

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?

Respected Advisor
Posts: 3,799

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

[ Edited ]

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**

 

Ask a Question
Discussion stats
  • 1 reply
  • 100 views
  • 0 likes
  • 2 in conversation