topic Merge issue / convert number to time8 format in SAS Procedures

Merge issue / convert number to time8 format

BETO — Sun, 13 Dec 2015 05:00:52 GMT

I Have two tables that I need to merge

data all;

Merge table1 table2;

by machine;

incomplete merge comes in only 3 Of 1k...

tablet1 time Column is format as number...I Need. To convert to time8

data Table2;

set table2;

format ttime time8.;

run;

the col comes back blank

Re: Merge issue / convert number to time8 format

Reeza — Sun, 13 Dec 2015 06:01:24 GMT

Please clarify your question.

Re: Merge issue / convert number to time8 format

BETO — Sun, 13 Dec 2015 17:43:19 GMT

How do I change the format on my time col to time ? I currently have it as a number in the description section The data looks like this 12:23:45 ... When I use the data step to change the format it comes back blank the col I wonder if it's even a number maybe it's a character? How do I convert character to number with a time8 format ?

Re: Merge issue / convert number to time8 format

Reeza — Sun, 13 Dec 2015 18:26:09 GMT

1. Figure out what it is, run a proc contents to see the variable type and format.
2. If it's a character, use input with the format to read it in as a different format (input(var, time8))