I have 94 years of data; I want to cumulate the data in groups of 35 years, and then calculate my metrics for years 2-36, then 3-37, etc.  I don’t know how to write macros, so I was looking at a do loop with n=1 to 35, but I don’t know how to  make it reset the variable back to the original values and work through the calculations again.  For instance, I have a withdrawal amount of $73,600.  I want it adjusted for inflation during each of the 35 years, but at the conclusion of the 35 years, I want the calculations done, and then return the withdrawal to $73,600 to start the calculations for years 2-36.   Here’s what I was trying:   data merg2;      by year; do n = 1 to 35;   Retain avg1 inflate portwith portwithtot savings dcatotbal DCAnewsav dcatotval1 saving totbal ;   N+1;   If N eq 1 then savings=1840000 ;      portwith=73600;   if avg1>0 then inflate = portwith*(1+(avg1/100)); else inflate = portwith; portwithtot + inflate - portwith;   *monthly withdrawals; bjan= savings*(lgwt*jan+govwt*gjan)-((portwith+portwithtot)/time); bfeb= savings*(lgwt*feb+govwt*gfeb)-((portwith+portwithtot)/time); bmar= savings*(lgwt*mar+govwt*gmar)-((portwith+portwithtot)/time); bapr= savings*(lgwt*apr+govwt*gapr)-((portwith+portwithtot)/time); bmay= savings*(lgwt*may+govwt*gmay)-((portwith+portwithtot)/time); bjun= savings*(lgwt*jun+govwt*gjun)-((portwith+portwithtot)/time); bjul= savings*(lgwt*jul+govwt*gjul)-((portwith+portwithtot)/time); baug= savings*(lgwt*aug+govwt*gaug)-((portwith+portwithtot)/time); bsep= savings*(lgwt*sep+govwt*gsep)-((portwith+portwithtot)/time); boct= savings*(lgwt*oct+govwt*goct)-((portwith+portwithtot)/time); bnov= savings*(lgwt*nov+govwt*gnov)-((portwith+portwithtot)/time); bdec= savings*(lgwt*dec+govwt*gdec)-((portwith+portwithtot)/time);   dcaBalance = bjan + bfeb + bmar + bapr + bmay + bjun + bjul + baug + bsep + boct + bnov + bdec; dcatotbal + dcaBalance; *savings +dcatotbal; *DCAnewsav = dcatotbal + savings; savings + dcabalance; end; run;   What is wrong with my setup?  Thank you. ... View more

Good evening, I haven't used SAS in awhile, and so before beginning writing my new program, I wanted to be sure an old program ran well.  I am using a different computer than what I used last time I ran SAS, so I took my data files and changed the location on the original program (original data was on an A drive; now it's on a D drive), and tried running the program.  I have a number of errors, but at the most basic level, it is not finding my data files.  Here is the message I receive:   ERROR: Physical file does not exist, /var/lib/sasstudio/studioconfig/D:\large70.txt. ERROR: Insufficient authorization to access /var/lib/sasstudio/studioconfig/D:\lzvgk.out.   This is how I entered my data files:   Filename lrg 'D:\large70.txt'; 74 Filename tbil 'D:\tbill70.txt'; 75 Filename sml 'D:\small70.txt'; 76 Filename gov 'D:\govbond70.txt'; 77 Filename corp 'D:\corpbond70.txt'; 78 Filename DCA1 'D:\lzvgk.out'; 79 Filename DCA2 'D:\Tgzv.out'; 80 Filename DCA3 'D:\small1.out'; 81 Filename DCA4 'D:\govbond1.out'; 82 Filename DCA5 'D:\corpbond1.out'; 83 Libname SASDATA 'D:\kleggio'; As I mentioned, this file did work previously (although it may be a new version of SAS since I ran this last.) Thanks very much for your help. ... View more