In this tutorial we will Populate first and last day of month and Year SAS. In order to populate first and last date of a month in SAS we will be using INTNX function. This function is also used to populate first and last date of year in SAS.
Let’s see an Example for Each
- Populate First date of a month in SAS
- Populate Last date of a month in SAS
- Populate First date of year in SAS
- Populate Last Date of year in SAS
So we will be using EMP_DET Table in our example
INTNX – Populate First date of a Month
In order to populate first date of a month in SAS we will be using INTNX() Function. It takes ‘month’ as argument along with ‘b’ which populates the first date of that particular month
data emp_det1;
set emp_det;
firstdate=intnx('month', Birthday, 0,'b');
format firstdate date9.;
run;
So the resultant table will be
INTNX – Populate Last date of a Month
In order to populate last date of a month in SAS we will be using INTNX() Function. It takes ‘month’ as argument along with ‘e’ which populates the last date of that particular month
data emp_det1;
set emp_det;
lastdate=intnx('month', Birthday, 0,'e');
format lastdate date9.;
run;
So the resultant table will be
INTNX – Populate First date of a year
In order to populate First date of year in SAS we will be using INTNX() Function. It takes ‘year’ as argument along with ‘b’ which populates the first date of that particular year
data emp_det1;
set emp_det;
firstdate=intnx('year', Birthday, 0,'b');
format firstdate date9.;
run;
So the resultant table will be
INTNX – Populate Last date of a Year
In order to populate last date of year in SAS we will be using INTNX() Function. It takes ‘year’ as argument along with ‘e’ which populates the last date of that particular year
data emp_det1;
set emp_det;
lastdate=intnx('year', Birthday, 0,'e');
format lastdate date9.;
run;
So the resultant table will be
