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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert number to a SAS datetime value
Thank you for your reply! My problem is a little bit different. SLFDATE is a numeric field of an Oracle database. For some reasons developers decided to store Dates as numeric values. I need to transfer data from this Database to a MSSQL Database to a table with DateTime field. My solution. I...- AlbertKM
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Convert number to a SAS datetime value
Hi I am trying to convert a date stored as number (20060731) to datetime value in SAS. So far I have tried - SLFDATE is a db field with a numeric value, representing date: input(put(SLFDATE,8.),yymmdd8.) AS FCSTDATE length=8 Thank you for your help.- AlbertKM
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
