topic Re: moving back date in SAS Procedures

moving back date

sasphd — Thu, 20 Sep 2018 17:01:59 GMT

I have dates in column A and I want to move back like that column B

Column B give the date at the end of the year before the date in column A

column A

19850331

19850630

19850930

19851231

19860331

19860930

19861231

19870331

column B

19841231

19851231

19861231

Re: moving back date

novinosrin — Thu, 20 Sep 2018 17:08:57 GMT

data have;
input a yymmdd10.;
format a yymmdd10.;
cards;                                  
19850331
19850630
19850930
19851231
19860331
19860930
19861231
19870331
;

data want;
set have;
b=intnx('year',a,-1,'e');
format b yymmdd10.;
run;

Re: moving back date

sasphd — Thu, 20 Sep 2018 17:12:50 GMT

thanks

and if I want just to come back by one month what I should do

Re: moving back date

novinosrin — Thu, 20 Sep 2018 17:19:06 GMT

Do you mean previous month of the same year and the last(end) date of the month?

Re: moving back date

sasphd — Thu, 20 Sep 2018 17:32:18 GMT

yes

Re: moving back date

novinosrin — Thu, 20 Sep 2018 17:37:07 GMT

data want;
set have;
b=intnx('month',a,-1,'e');
format b yymmdd10.;
run;