Help using Base SAS procedures

convert variable numeric time (hours,min) to character variable $7

Accepted Solution Solved
Reply
Super Contributor
Posts: 301
Accepted Solution

convert variable numeric time (hours,min) to character variable $7

Hi everyone, I am interesting to put the final numeric variable time I got, for example 176:30...in a character variable: 176:30 with format $7

Any help? Thnaks. V.

data have;

input hours 8.;

datalines;

0

176.5

1.25

2.5

3

;;;

run;

data want;

set have;

format time HHMM7.;

time = hours*3600;

run;

proc print; run;


Accepted Solutions
Solution
‎07-26-2012 02:30 PM
PROC Star
Posts: 7,416

Re: convert variable numeric time (hours,min) to character variable $7

One way would be:

data have;
  input hours 8.;
  datalines;
0
176.5
1.25
2.5
3
;

data want;
  set have;
  time = put(hours*3600,HHMM7.);
run;

View solution in original post


All Replies
Solution
‎07-26-2012 02:30 PM
PROC Star
Posts: 7,416

Re: convert variable numeric time (hours,min) to character variable $7

One way would be:

data have;
  input hours 8.;
  datalines;
0
176.5
1.25
2.5
3
;

data want;
  set have;
  time = put(hours*3600,HHMM7.);
run;

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 958 views
  • 0 likes
  • 2 in conversation