SAS: PROC SQL: How to convert a character format column to time format
up vote
-1
down vote
favorite
I have a column which is in character format and has entries as hh:mm:ss. How can I convert character format to time format using proc sql in sas?
sql sas
asked 17 hours ago
Abhas Jangre
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
-1
down vote
favorite
I have a column which is in character format and has entries as hh:mm:ss. How can I convert character format to time format using proc sql in sas?
sql sas
asked 17 hours ago
Abhas Jangre
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please show what you've tried in the future.
– Reeza
11 hours ago
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have a column which is in character format and has entries as hh:mm:ss. How can I convert character format to time format using proc sql in sas?
sql sas
asked 17 hours ago
Abhas Jangre
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a column which is in character format and has entries as hh:mm:ss. How can I convert character format to time format using proc sql in sas?
sql sas
sql sas
asked 17 hours ago
Abhas Jangre
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 17 hours ago
Abhas Jangre
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 17 hours ago
Abhas Jangre
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 17 hours ago
Abhas Jangre
21
asked 17 hours ago
Abhas Jangre
21
21
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Abhas Jangre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please show what you've tried in the future.
– Reeza
11 hours ago
add a comment |
Please show what you've tried in the future.
– Reeza
11 hours ago
Please show what you've tried in the future.
– Reeza
11 hours ago
Please show what you've tried in the future.
– Reeza
11 hours ago
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You should be able to use the input function with a format (time8.) to convert the value. The original column will not change its type from char, so you can create another column to hold the numeric value.
If you need something else then please edit your question with an expanded explanation and an example.
/* set up data */
data have;
input char_time : $8.;
datalines;
00:00:00
01:02:03
23:59:59
;
/* create a column in time8. format */
proc sql noprint;
create table
want as
select
char_time
,input(char_time,time8.) as num_time format = time8.
from
have
;
quit;
answered 16 hours ago
Amir
7011410
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You should be able to use the input function with a format (time8.) to convert the value. The original column will not change its type from char, so you can create another column to hold the numeric value.
If you need something else then please edit your question with an expanded explanation and an example.
/* set up data */
data have;
input char_time : $8.;
datalines;
00:00:00
01:02:03
23:59:59
;
/* create a column in time8. format */
proc sql noprint;
create table
want as
select
char_time
,input(char_time,time8.) as num_time format = time8.
from
have
;
quit;
answered 16 hours ago
Amir
7011410
add a comment |
up vote
0
down vote
You should be able to use the input function with a format (time8.) to convert the value. The original column will not change its type from char, so you can create another column to hold the numeric value.
If you need something else then please edit your question with an expanded explanation and an example.
/* set up data */
data have;
input char_time : $8.;
datalines;
00:00:00
01:02:03
23:59:59
;
/* create a column in time8. format */
proc sql noprint;
create table
want as
select
char_time
,input(char_time,time8.) as num_time format = time8.
from
have
;
quit;
answered 16 hours ago
Amir
7011410
add a comment |
up vote
0
down vote
up vote
0
down vote
You should be able to use the input function with a format (time8.) to convert the value. The original column will not change its type from char, so you can create another column to hold the numeric value.
If you need something else then please edit your question with an expanded explanation and an example.
/* set up data */
data have;
input char_time : $8.;
datalines;
00:00:00
01:02:03
23:59:59
;
/* create a column in time8. format */
proc sql noprint;
create table
want as
select
char_time
,input(char_time,time8.) as num_time format = time8.
from
have
;
quit;
answered 16 hours ago
Amir
7011410
You should be able to use the input function with a format (time8.) to convert the value. The original column will not change its type from char, so you can create another column to hold the numeric value.
If you need something else then please edit your question with an expanded explanation and an example.
/* set up data */
data have;
input char_time : $8.;
datalines;
00:00:00
01:02:03
23:59:59
;
/* create a column in time8. format */
proc sql noprint;
create table
want as
select
char_time
,input(char_time,time8.) as num_time format = time8.
from
have
;
quit;
answered 16 hours ago
Amir
7011410
answered 16 hours ago
Amir
7011410
answered 16 hours ago
Amir
7011410
answered 16 hours ago
Amir
7011410
7011410
add a comment |
add a comment |
Abhas Jangre is a new contributor. Be nice, and check out our Code of Conduct.
Abhas Jangre is a new contributor. Be nice, and check out our Code of Conduct.
Abhas Jangre is a new contributor. Be nice, and check out our Code of Conduct.
Abhas Jangre is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53224066%2fsas-proc-sql-how-to-convert-a-character-format-column-to-time-format%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Please show what you've tried in the future.
– Reeza
11 hours ago