Try upgrading to version 8.2 of SAS. The newer versions of SAS/ACCESS to ORACLE are a pretty sweet and a lot smarter than the version 6 equivalents. To see what version of this product you have, try submitting the following code:
proc setinit noalias;
run;
Look towards the bottom for a...
Here's a macro from SAS Institute that should do the trick for you:
1. Go to http://ftp.sas.com/techsup/download/base/
2. Download:
macroexporternew.sas to export multiple SAS Data Sets to multiple Excel spreadsheets or multiple MS Access files.
macroexporterexisting.sas to update...
Not to beat a dead horse, but I'd stay away from INTCK and INTNX because both use the beginning of the interval specified (unless this is what you want).
INTNX('interval',start-from,increment<,'alignment'>)
For example, if today's date were March 31, 2002, then INTNX('MONTH',today(),-6)...
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.