Write and run SAS programs in your web browser

Time Conversion

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Time Conversion

hi,

 

i have numeric data in hundreths place like

250

103

356

 which i want to convert it in the Time format of hhmm.

 

Thanks.

 


Accepted Solutions
Solution
‎07-26-2016 01:48 AM
Super User
Super User
Posts: 6,849

Re: Time Conversion

You could just use some arithmetic and the HMS() function.

time=hms(int(number/100),mod(number,100),0);

Or you could add some leading and trailing zeros to make it look like HHMMSS string and use the INPUT() function.

time=input(put(100*number,z6.),B8601TM6.);

View solution in original post


All Replies
Super Contributor
Posts: 260

Re: Time Conversion

What is your desired output.

 

do you want to see your data as mentioned below

 

02:50

01:03

03:56

 

 

Solution
‎07-26-2016 01:48 AM
Super User
Super User
Posts: 6,849

Re: Time Conversion

You could just use some arithmetic and the HMS() function.

time=hms(int(number/100),mod(number,100),0);

Or you could add some leading and trailing zeros to make it look like HHMMSS string and use the INPUT() function.

time=input(put(100*number,z6.),B8601TM6.);
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 265 views
  • 1 like
  • 3 in conversation