topic Re: Converting time to character in SAS Procedures

Converting time to character

BETO — Fri, 15 Nov 2013 22:36:00 GMT

HI Im having and issue with a time column.

the column is a time9. 14:04:00

WHat i need to pull is the hour segment 14

when I did is a data step

data report;

set report;

hour= substr( left( time) ,2,4);

it gives the sas date of 50640. This is what it pulls in 0640 But the col I'm refer looks like this 14:04:00

thanks for your assistance

Re: Converting time to character

PGStats — Fri, 15 Nov 2013 22:51:19 GMT

If your time variable is a true SAS time value, you should use hour = hour(time) to get the hour number or hour=put(hour(time),best.) to get the character representation.

If time is a character representation of time then you should use hour = scan(time,1,":") . - PG

Re: Converting time to character

BETO — Sat, 16 Nov 2013 00:29:59 GMT

HI PGStats,

the hour did work it gave me the hour. But it converted it to a character for example

14:04:00 it gave me a 14 as a character what can i do within the datastep to make it a number? THANKS

data report;

set report;

hour=hour(time):

run;

Re: Converting time to character

PGStats — Sat, 16 Nov 2013 03:14:31 GMT

It must be that variable hour is already declared as a character variable prior to the hour=hour(time) statement. Look at SAS log, there must be a statement such as:

NOTE: Numeric values have been converted to character

values at the places given by: (Line):(Column).

Try the following test:

data report;

length hourText $8; /* Declare hourText as a character variable */

time = '14:30:00't; /* time is a true SAS time value */

hourText = hour(time); /* Implies a conversion to character */

hourNumber = hour(time); /* Number result is assigned to a numeric variable (by default) */

run;

proc print; run;

If you want to get a number, assign the result of hour(time) to a variable that hasn't been declared as a character variable.

Re: Converting time to character

anonymous_user — Mon, 18 Nov 2013 08:38:28 GMT

if for some reason the variable is in a character format you can allways create a new variable and converet it to a numeric format using input .

for example :

data report;

set report;

hour=hour(time);

hour1=input(hour,12.);

run;

good luck