topic Re: What is the "month12.7" format? in SAS Programming

What is the "month12.7" format?

ywon111 — Thu, 10 Mar 2022 23:14:54 GMT

Looks like it is throwing the end of June quarter. How do I get other quarter? Eg. March, December?

Re: What is the "month12.7" format?

ballardw — Thu, 10 Mar 2022 23:28:23 GMT

Example input data? Example code? Example output?

The documentation for the MONTHw. format does not show a decimal component and would display the month number of a date value.

Example displaying the month a date. Nothing to do with quarters.

61   data example;
62      x = '15Jun2021'd;
63      put x=date9. 'Month number: ' x=month12.7;
64   run;

x=15JUN2021 Month number: x=6

Re: What is the "month12.7" format?

Kurt_Bremser — Fri, 11 Mar 2022 07:00:35 GMT

Is it possible that you are not talking about formats, but the first argument to a INTNX or INTCK function?

Re: What is the "month12.7" format?

Ksharp — Fri, 11 Mar 2022 11:55:43 GMT

It seems you are talking about INTNX() .

data _null_;
today=date();
start_july1=intnx('month12.7',today,0,'e');
start_july2=intnx('year.7',today,0,'e');

put today=  yymmdd10.  start_july1= yymmdd10.  start_july2=  yymmdd10. ;
run;