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
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
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.
Hi,
You can do this in IMAP by just changing the valid width range to 3(for monname format).
Thanks,
Shiva
HI shivas,
Thanks
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.