Hi -
Please forgive this newbie question. I have looked online extensively and have not been able to solve it.
I have a variable, 'time', that contains timestamps that look like this:
0:00:01
0:00:16
15:53:46
This variable is currently in character format ($8). I have tried the recommended tricks to convert it to numeric. Here are some examples of what I have tried:
data file1; set file;
infile ".........";
input time $8;
fmttime=input(time,8.);
run;
data file1; set file;
fmttime=time * 1;
run;
data file1; set file;
fmttime=put(time,12.);
run;
None of these are working. How would others go about doing this conversion?
Thank you!
Try
fmttime = input(time, time8.);
This will create a time value that can be manipulated with the time functions such as INTNX or INTCK and a format of time8. would display as a time value.
Your attempts failed because the f8. format can't handle :
the multiple failed because it can't handle : either.
Try
fmttime = input(time, time8.);
This will create a time value that can be manipulated with the time functions such as INTNX or INTCK and a format of time8. would display as a time value.
Your attempts failed because the f8. format can't handle :
the multiple failed because it can't handle : either.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.