Quarter from date

[SASdevAnneMarie]

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 ! 

[Ksharp · Accepted solution]

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 秒

[SASdevAnneMarie]

Thank you, Ksharp !

[Ksharp]

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 秒