topic Re: Quarter from date in SAS Programming

Quarter from date

SASdevAnneMarie — Wed, 21 Jan 2026 08:35:58 GMT

Hello Experts,

I am wondering why I have this error :

Trimestre=put(datepart("Date vers"n), QNYYYY.);
                                                       _______
                                                       484
NOTE 484-185: Format QNYYYY was not found or could not be loaded.

Thank you for your help !

Re: Quarter from date

Ksharp — Wed, 21 Jan 2026 09:50:20 GMT

Your format was invalid. Try other sas build-in format:

options validvarname=any;
data _null_;
"Date vers"n=datetime();
Trimestre=put(datepart("Date vers"n), yyqd6.);
put Trimestre;
Trimestre=put(datepart("Date vers"n), yyq6.);
put Trimestre;
Trimestre=put(datepart("Date vers"n), yyqn6.);
put Trimestre;

run;

29   data _null_;
30   "Date vers"n=datetime();
31   Trimestre=put(datepart("Date vers"n), yyqd6.);
32   put Trimestre;
33   Trimestre=put(datepart("Date vers"n), yyq6.);
34   put Trimestre;
35   Trimestre=put(datepart("Date vers"n), yyqn6.);
36   put Trimestre;
37
38   run;

2026-1
2026Q1
20261
NOTE: “DATA 语句”所用时间（总处理时间）:
      实际时间          0.01 秒
      CPU 时间          0.01 秒

Re: Quarter from date

Ksharp — Wed, 21 Jan 2026 09:53:57 GMT

Or customize it on your own.

40   data _null_;
41   "Date vers"n=datetime();
42   Trimestre=cats(qtr(datepart("Date vers"n)),year(datepart("Date vers"n)) );
43   put Trimestre;
44   Trimestre=cats(qtr(datepart("Date vers"n)),'Q',year(datepart("Date vers"n)) );
45   put Trimestre;
46   run;

12026
1Q2026
NOTE: “DATA 语句”所用时间（总处理时间）:
      实际时间          0.01 秒
      CPU 时间          0.01 秒

Re: Quarter from date

SASdevAnneMarie — Wed, 21 Jan 2026 10:25:48 GMT

Thank you, Ksharp !