Looks like it is throwing the end of June quarter. How do I get other quarter? Eg. March, December?
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
Is it possible that you are not talking about formats, but the first argument to a INTNX or INTCK function?
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.