Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ucandoit
- Order by date
-
SAS - Oracle date problems
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...- ucandoit
- Post #2
- Forum: SAS Institute, Inc. solutions
-
Calculating the age of a file eg to show all files > 6 months
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...- ucandoit
- Post #6
- Forum: SAS Institute, Inc. solutions
-
Calculating the age of a file eg to show all files > 6 months
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)...- ucandoit
- Post #5
- Forum: SAS Institute, Inc. solutions
