@abcrandy wrote: Thanks ballardw . That worked like a charm! One last thing. How do I remove the "MO=" to only show the month name? Easiest might be an additional title statement coupled with the nobyline option. proc sort data=sashelp.class out=work.class; by sex; run; options nobyline; title ' #byval(sex) ' ; proc print data=work.class noobs; by sex; var name; run; title; options byline; use a title with a higher number such as title2 than the ones you are currently using to make sure that if follows your existing one.   Don't forget to reset the option byline to return to the default behavior. the last title statement clears the title so you don't get that title on other output. ... View more

Hi: Well, this example did not have MONTH, since it used YEAR and QUARTER. But I'd probably use a date with a SAS format or a format like MONNAME if all I had was a month value of 1-12. Cynthia ps...next time, start a new post and refer back to this 2 year old posting. Nobody can see the older tracks. ... View more

Thanks, this worked. Your awesome Cynthia_sas ... View more