|Date: ||Wed, 26 Apr 2000 08:18:47 -0400|
|Reply-To: ||"Miller, Scott" <scott.miller@CAMCARE.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Miller, Scott" <scott.miller@CAMCARE.COM>|
|Subject: ||Re: SQL and variable formats|
|Content-Type: ||text/plain; charset="iso-8859-1"|
i have that same problem when pulling data from oracle. my solution may be
brute force, but is simple:
format new_date mmddyy10.;
new_date=old_date/86400; (i divide the datetime variable by the number of
seconds in a day)
Scott D. Miller, M.A.
Medical Informatics Analyst/SAS Programmer
Center for Health Services and Outcomes Research
CAMCARE Health Education and Research Institute
"Every good scientist is one part B.F. Skinner and one part P.T. Barnum"
Another Month Ends...All Targets Met...All Systems Working...
All Staff Eager and Enthusiastic...All Pigs Fed and Ready to fly
From: Philp, Stephen R. [mailto:Stephen.Philp@CSHS.ORG]
Sent: Tuesday, April 25, 2000 5:59 PM
Subject: SQL and variable formats
I have some pass-through SQL going against some Oracle tables and am having
a hard time trying to figure out how to format a date. The variable in my
new table is a sas date with a datetime format (01DEC1998:00:00:00), but
when I try to format it to mmddyy10. it has invalid data.
Could anyone offer some help?