topic "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 13.2 in SAS Data Science

"Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 13.2

touchspeed — Mon, 15 Feb 2016 15:50:58 GMT

When I run the TS data Preparation Node after importing a time series raw data in Excel format, not matter how I change the date/time format in excel, I always got the error message“Invalid Timeid"

The sample of the raw data and error massage snapshot are attached following.

Anyone can help?

Many thanks

Kev

Re: "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 1

Reeza — Mon, 15 Feb 2016 19:57:26 GMT

Did you specify the type somewhere? If so, please so that screen shot. The date appears to be a Date variable.

Re: "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 1

touchspeed — Tue, 16 Feb 2016 01:59:16 GMT

Yes, I did it by assigning the "Time ID" role to "Month_of checkin_date" as per following screen shot:

Re: "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 1

Reeza — Tue, 16 Feb 2016 02:36:54 GMT

Go back a step, how did you specify it in the import. My guess is it's coming in as a character var instead of numeric/SAS date variable.

Re: "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 1

touchspeed — Tue, 16 Feb 2016 06:42:58 GMT

Many Thanks!

It's working now. I think the variable name I used, "Month of check-in date" containing both "Month" and "date", which cause the system fail to recognize the date values. Now I change the Variable name into "Month", and the imported date value from my excel file can be proceeded as "TimeID" in "TS Data Preparation" Node.

Re: "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 1

Stewartli — Sat, 16 Dec 2017 00:42:08 GMT

Hi Guys,

I use SAS Enterprise Miner 14.2 and have the same problem now. Can someone tell me what went wrong? Thank you very much.

Re: "Invalid Timeid Error Message" from TS data Preparation Node in SAS Enterprise Miner 1

Stewartli — Sat, 16 Dec 2017 01:14:29 GMT

I found the answer. Please refer to the link below.

http://documentation.sas.com/?docsetId=emref&docsetTarget=n0rzjozmp6um16n164o5w43nsaax.htm&docsetVersion=14.3&locale=en