Thanks everyone for all the great input. I finally got this to work last night. Here is the code that i used below, which was a direct variation of what Tom posted last night. data work.want; set WORK.QUERY_FOR_TEST; format time time8.; time=.; word=response_time__avg_; do i=1 to 3 ; word=scan(response_time__avg_,i,' '); select ( substr(word,length(word))); when ('s') time+input(compress(word,'s'),12.); when ('m') time+60*input(compress(word,'m'),12.); when ('h') time+60*60*input(compress(word,'h'),12.); otherwise ; end; end; put time time8. ' <- ' response_time__avg_; cards; run; Japp - I hear ya man! I get excel data from one of our vendors that holds daily raw data... so when that comes in my inbox... i have VBA setup to move that to a network location... then have my EG project scheduled to run... so it picks up the file and runs it. I don't even look at the raw data files anymore. Unfortunately, they just changed their system and i have been rebuilding the project based on the new file structure. Tom - Thank you so much... i think i fell off my chair when i saw a column of time formatted data... i was elated to see that column! This is a huge win and I appreciate you help! Thanks, Dean
... View more