Traditional web-based reporting with SAS BI tools

show date in short month name, e.g. Jan, feb

Reply
Contributor
Posts: 21

show date in short month name, e.g. Jan, feb

show date in short month name, e.g. Jan, feb. I found that there is only MONNAME in information map. how do I add such user-defined format for date in informartion map? I used sas 9.3

Trusted Advisor
Posts: 1,137

Re: show date in short month name, e.g. Jan, feb

Hi, you can pull the short date form using the below code if the date is in numeric format.

data date;

date=substr(put(today(),date9.),3,3);

run;

If the date is in month name then you can use the substr function to extract the first three letters from the month name like

sunstr(monname,1,3);

Thanks,

Jag

Thanks,
Jag
Contributor
Posts: 21

Re: show date in short month name, e.g. Jan, feb

Hi Jag,

I have question that In which part of Web Report Studio and Information Map Studio run the code:

============

data date;

date=substr(put(today(),date9.),3,3);

run;

============

Please help to indicate.

Super Contributor
Posts: 349

Re: show date in short month name, e.g. Jan, feb

Hi,

You can do this in IMAP by just changing the valid width range to 3(for monname format).

Thanks,

Shiva

Imap.png

Contributor
Posts: 21

Re: show date in short month name, e.g. Jan, feb

HI shivas,

Thanks

Ask a Question
Discussion stats
  • 4 replies
  • 2439 views
  • 2 likes
  • 3 in conversation