topic Re: Converting a number to a date (yyyy/mm/dd hh:mm) in New SAS User

Converting a number to a date (yyyy/mm/dd hh:mm)

EmmanuelCamden — Tue, 18 Feb 2020 10:08:32 GMT

I'm pulling data from a database to load into another database. The file spec I've been given says the date I need to provide be in yyyy/mm/dd hh:mm format.

The date field I'm pulling is in SQL Server and it's a datetime field, but from the SAS library side of things it shows as "Number". How can I have it export to my Excel export as a date, and in the yyyy/mm/dd hh:mm format? (e.g. 2019/04/01 00:00)

Re: Converting a number to a date (yyyy/mm/dd hh:mm)

AnilReddy — Tue, 18 Feb 2020 11:35:58 GMT

Here is the formula,

Date DMY(
Num( Substr( :date, 7, 2 ) ),
Num( Substr( :date, 5, 2 ) ),
Num( Substr( :date, 1, 4 ) ) ) +
60 * 60 * Num( Word( 2, :date, " :" ) ) +
60 * Num( Word( -1, :date, " :" ) )

try this once

Re: Converting a number to a date (yyyy/mm/dd hh:mm)

andreas_lds — Tue, 18 Feb 2020 12:31:50 GMT

@EmmanuelCamden: you do know that sas stores dates, times and datetimes as numbers and that formats are used to display the values in a human-readable form?