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.
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.
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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.