I am trying to input a time value that is given in 00:00:00 (Hour:Minuteecond) Format. I am wondering how I can input this so SAS converts it to all seconds so I can subtract and add the times to eachother. I then need to convert it back to the Hour:Minuteecond time format. Anyone know the imput function command or how I could do this? I am pulling the data from a .csv file. Thanks for any help.
You can use the SAS INPUT function in a DATA step to convert a text-string in the format you mentioned in your post to a SAS numeric variable. When converted, the value will represent seconds, and so then you choose a SAS FORMAT to display your data as needed.
The SAS support website http://support.sas.com/ and its SEARCH facility can provide both documentation and supplemental technical conference topic material.