Hello,
I asked a question earlier about this issue. I will try to rephrase my question.
I have a dataset that have three variables: period (datevar.), sales and depart. The time series starts in 2021-01-01 and grows every month when a new month’s sales figures is added. The data for the latest months (in this example 2022-02-01 and 2022-03-01) is not reliable.
For now, I am using a macro that I must update every month. With the macro I select the starting date and the end date (current date minus two months.)
I would like to create a macro, with TODAY Function or something else, so I can automatically select starting date (2021-01-01) and end date (current date minus two months: 2021-01-01). I would like to achieve this without needing to update the macro every month.
data have;
;
input period :yymmdd10. sales depart$;
format period yymmddd10.;
datalines;
2021-01-01 200 Sales
2021-02-02 150 Sales
2021-03-01 320 Sales
2021-04-01 220 Sales
2021-05-01 250 Sales
2021-06-01 320 Sales
2021-07-01 400 Sales
2021-08-01 550 Sales
2021-09-01 900 Sales
2021-10-01 550 Sales
2021-11-01 850 Sales
2021-12-01 750 Sales
2022-01-01 650 Sales
2022-02-01 100 Sales
2022-03-01 25 Sales
;
run;
%let time=('01jan2021'd<=period<='01jan2022'd);
data out;
set have;
if &time.;
run;
data want;
;
input period :yymmdd10. sales depart$;
format period yymmddd10.;
datalines;
2021-01-01 200 Sales
2021-02-02 150 Sales
2021-03-01 320 Sales
2021-04-01 220 Sales
2021-05-01 250 Sales
2021-06-01 320 Sales
2021-07-01 400 Sales
2021-08-01 550 Sales
2021-09-01 900 Sales
2021-10-01 550 Sales
2021-11-01 850 Sales
2021-12-01 750 Sales
2022-01-01 650 Sales
... View more