01-23-2017 05:13 PM
If it's a string, you will need to assign the date value to a new variable since SAS stores dates as numeric:
newvar = input(stringvar, yymmdd8.);
If you actually have separators in your string, such as yyyy/mm/dd you will need to expand the width:
newvar = input(stringvar, yymmdd10.);
This gives you a SAS date (not a datetime). While you can convert this to a datetime value, it's not clear why you would want to do that. You don't actually have any measurement of hours, minutes, or seconds in your data.
01-24-2017 05:10 PM
Thank you, the reason I want to convert to datetime is because I'm learning how to handle both SAS date and datetime formats
01-23-2017 05:29 PM
Don't forget to assign a format to the variable so you can see the date value instead of the internal numeric stored value.
If you have a date and time parts the function DHMS will create a datetime variable:
DT = dhms(date, hours, minutes, seconds);
If you don't have any time values you can set a default such as
DT = dhms(date,0,0,0); which would be midnight at the start of the day.
01-25-2017 03:29 AM
SAS Date values are stored as the number of days since 1960/01/01
SAS Time values are stored as the number of seconds since midnight
SAS Datetime values are stored as the number of seconds since 1960/01/01
Knowing that, you can easily switch between Date, Datetime and time values just by doing some maths:
DATETIME = DATE*(24*60*60)
DATE = int(DATETIME/(24*60*60))
TIME = mod(DATETIME,24*60*60)
Or you could use the dedicated functions:
Datepart, that will return the Date value of it's Datetime value argument
Timepart, that will return the Time vale of it's Datetime value argument
DHMS, that will return the Datetime value of it's Date value argument (+ the hour, minute and second specified)
More on Date, Datime and Time values here:
Hope it helps.
Daniel Santos @ www.cgd.pt