Hi, Thanks for those answers, I indeed could have been a bit more specific. The finality was to feed the values in that particular format into the following parameters that are use throughout the program. I've inserted more code below, adding on what I previously sent.
data datez ;
ThisDate= Date();
FirstDayOfMonth = IntNX("Month", ThisDate, 0);
FirstDayOfLastMonth = IntNX("Month", ThisDate, -1);
StudyStart = IntNX("Month", ThisDate, -12);
StudyEnd = IntNX("Month", ThisDate, 0)-1;
OneYearAgo = IntNX("Month", ThisDate, -12);
date_strt = IntNX("Month", ThisDate, -15);
date_end = IntNX("Month", ThisDate, -3)-1;
currentyear = YEAR(FirstDayOfLastMonth);
curntyear = YEAR(FirstDayOfLastMonth)-2000;
monthclsng = (MONTH(FirstDayOfLastMonth));
FirstDayOfYear = IntNX("Year", ThisDate, 0);
format ThisDate DDMMYY.;
format FirstDayOfMonth YYMMDDN6.;
format FirstDayOfLastMonth YYMMDDN6.;
format OneYearAgo YYMMDDN6.;
format StudyStart YYMMDDN8.;
format StudyEnd YYMMDDN8.;
format date_strt YYMMDDN8.;
format date_end YYMMDDN8.;
format monthclsng Z2.;
format FirstDayOfYear YYMMDDN6.;
run ;
/* parameters*/
%let base_polvig = &FirstDayOfMonth ;
%let base_polvig_old = &FirstDayOfLastMonth ;
%let base_polvig_old1 = &FirstDayOfYear ;
%let base_polvig_old_old = &OneYearAgo ;
%let annee = ¤tyear ;
%let an = &curntyear ;
%let mois = &monthclsng ;
%let deb_etude = &StudyStart ;
%let fin_etude = &StudyEnd ;
%let date_deb1 = &date_strt ;
%let date_fin1 = &date_end;
Thanks 🙂
... View more