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: 5,970

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
Regular Contributor
Posts: 227

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: 5,970

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.);
Post a Question
Discussion Stats
  • 2 replies
  • 172 views
  • 1 like
  • 3 in conversation