Karlo
Best wishes but i think you may be out of luck. According to the SAS institute web site :-
In SAS 8.2, using PROC EXPORT to write a SAS data set to an Excel file,
and that Excel file exists, the entire Excel file is replaced when code
similar to this is used:
PROC EXPORT...
Seems like i worked it out myself.
currend = MDY(Month(currstrt), Day(currstrt), Year(currstrt) + termintv);
where currstrt is the start point and termintv contains a numeric value to increase the year portion of currstrt.
I have a number of products all of which have a start date they then have an indicator which shows the interval factor for its end date 1 = years 2 = months and a further field which indicates how many years / months. So for example start date 08dec2004 interval factor 1 interval period 7. This...
I am reading an input file with in excess of 125,00 recs, (and increasing all the time). I want to break it down into SAS output tables with 15,000 recs on each with the remainder on the final file. I have to keep changing my code to accomodate the increasing number of files. Is there any way to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.