Hello,
What I am doing here is working however I'm curious if there is a better way...
1. I have 12 different "PerioidLabelBuckets" that can all be formatted the same. Currently, I have 12 format statements for each bucket (you can see in my attachment). Is there a way to write one format statement that will take care of all the PeriodLabelBuckets?
2. I ideally would like the date formatted as mon-yy (DEC-19). Right now the format is monyy. so it shows DEC19. There are examples of how to do this on the SAS community but I'm having a hard time getting understanding how it works and how to apply it to my program. I'm using SAS Enterprise Guide 8.1.
Do i need a proc format statement with EG?
The examples I've seen have proc format;
picture monyyd (default=6)
fmtA = '%b-%y' (datatype=date);
then a data _null_ statement....?
I'm new to SAS and hoping for a little guidance.
thank you!