Hello,
Does anyone understand why my format is is returning a value of 01/01/1960? Thanks in advanced!
My code is below and my unformatted data is as follows:
- collection_date: date11. (i.e., 19-JUL-2017)
- pctim = character (i.e., 10:55, 10:10, 11:55 etc.)
if nmiss (collection_date)= 0
then do ;
pcdt = collection_date;
pcdtc = put(collection_date + input(pctim, time5.),e8601dt.) ;
end;
try using dhms to create a datetime value using date and time value
Assuming your date is a sas numeric date
datetime=put(dhms(collect_date,0,0,input(pcttm,time5.)),e8601dt.);
and then apply an appropriate format
try using dhms to create a datetime value using date and time value
Assuming your date is a sas numeric date
datetime=put(dhms(collect_date,0,0,input(pcttm,time5.)),e8601dt.);
and then apply an appropriate format
Thank you so much!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.