topic Re: Getting the month name in SAS Programming

Getting the month name

SASdevAnneMarie — Wed, 11 Dec 2024 13:18:56 GMT

Hello Experts,

I'm getting the month name applying the function monname : put(datepart(mon_jour),monname.) .

Do you know, please, how to display the month in French ?

Thank you for your help !

Re: Getting the month name

yabwon — Wed, 11 Dec 2024 13:30:39 GMT

options LOCALE=fr_FR;

data _null_;
mon_jour=datetime();
x = put(datepart(mon_jour),NLDATEMN.);
put x=;
run;

options LOCALE=en_US;

Re: Getting the month name

PaigeMiller — Wed, 11 Dec 2024 13:32:10 GMT

options locale=fr_FR;
data fake;
   today=today();
   want=put(today,NLDATEMN.) ;
run;

Re: Getting the month name

SASdevAnneMarie — Wed, 11 Dec 2024 15:35:40 GMT

Thank you, Yabwon!

Re: Getting the month name

Tom — Wed, 11 Dec 2024 17:10:43 GMT

Good to know. And NLDATENM does not have MONNAME's nasty habit of right aligning the text.

data months;
  do mofy=1 to 12;
    date=mdy(mofy,1,2024);
    month=put(date,monname.);
    month2=put(date,nldatemn.);
    output;
  end;
  format date yymmdd10.;
run;

proc print ;
 format _character_ $quote.;
run;

Obs    mofy          date       month       month2

  1      1     2024-01-01    "  January"    "January"
  2      2     2024-02-01    " February"    "February"
  3      3     2024-03-01    "    March"    "March"
  4      4     2024-04-01    "    April"    "April"
  5      5     2024-05-01    "      May"    "May"
  6      6     2024-06-01    "     June"    "June"
  7      7     2024-07-01    "     July"    "July"
  8      8     2024-08-01    "   August"    "August"
  9      9     2024-09-01    "September"    "September"
 10     10     2024-10-01    "  October"    "October"
 11     11     2024-11-01    " November"    "November"
 12     12     2024-12-01    " December"    "December"