Basic Concepts: %let med =%sysfunc(intnx(month,(&today),0,e),DDMMYYD10.); /* month last date */ %let msd = %sysfunc(intnx(month,(&today),0,b),DDMMYYD10.); /* month first date */ %let mth = %sysfunc(putn(&today, YYMMN.)); /* year and month */ /* Generating: '200131':*/
%let med2 =%sysfunc(intnx(month,(&today),0,e),YYMMDD7.); /* month last date Teradata format */ %let today=%sysfunc(today());
%let currdt=%sysfunc(datetime());
%let med =%sysfunc(intnx(month,(&today),0,e),DDMMYYD10.); /* month last date */
%let msd = %sysfunc(intnx(month,(&today),0,b),DDMMYYD10.); /* month first date */
%let mid = (((Extract (YEAR From &med) - 1990 )* 12 ) + (Extract (MONTH From &med))); /* month last date */
%let mth = %sysfunc(putn(&today, YYMMN.)); /* year and month */
%let med2 =%sysfunc(intnx(month,(&today),0,e),YYMMDD7.); /* month last date Teradata format */
%let msd2 =%sysfunc(intnx(month,(&today),0,b),YYMMDD7.); /* month last date Teradata format */
%let prevmed = DATE&msd-1; /* month first date */
%let prevmid = (((Extract (YEAR From Add_Months(&msd,-1)-1) - 1990 )* 12 ) + (Extract (MONTH From Add_Months(&msd,-1)+0))); /* month first date */
options mprint mlogic symbolgen;
... View more