topic Re: Some help importing some time data. in SAS Procedures

Some help importing some time data.

iiibbb — Wed, 08 Feb 2012 23:26:14 GMT

I am trying to import a GIS field that contains time data. SAS is

importing it from Excel as a character string, but I need to convert it to a time

string. I can 't seem to figure out how.

Examples of the field is

10:12:56am

11:23:23am

12:43:23pm

03:45:21pm

05:23:53pm

I am a little befuddled.

Some help importing some time data.

data_null__ — Wed, 08 Feb 2012 23:45:15 GMT

Read the variable with TIME10. informat.

time = input(xltime,time10.);

Re: Some help importing some time data.

iiibbb — Thu, 09 Feb 2012 00:02:20 GMT

Explain further...

if I import the data using the import data menu, and create a permanent dataset in a library.

Then I create a temporary dataset and convert the variable using that formula?

It might help to note that Excel doesn't recognize it as a time field either.

Re: Some help importing some time data.

Tom — Thu, 09 Feb 2012 00:20:30 GMT

Import it as a temporary dataset and then use a data step to create the permanent dataset with the time variable converted.

Re: Some help importing some time data.

iiibbb — Thu, 09 Feb 2012 00:25:40 GMT

say the variable's name is GPS_Time.

Could you please give me an example of that syntax?

I tried adding it, but apparently I'm putting it in the wrong place.

Thank you

Re: Some help importing some time data.

art297 — Thu, 09 Feb 2012 00:30:08 GMT

data want (drop=in_:);

set have (rename=GPS_Time=in_time);

format GPS_Time time10.;

GPS_Time = input(in_time,time10.);

run;

Re: Some help importing some time data.

iiibbb — Thu, 09 Feb 2012 01:03:47 GMT

Thank you.

Sometimes I wonder if I'm ever going to understand some of this syntax... but I've always had so much control over my data before moving to SAS and thus, my code has always been clean and simple. This automated stuff is really making me realize how much I don't know.

Thanks