moving back date

[sasphd]

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

19841231

19841231

19841231

19851231

19851231

19851231

19861231

[novinosrin · Accepted solution]

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;

[sasphd]

thanks 

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

[novinosrin]

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

[sasphd]

yes

[novinosrin]

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