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

[touchspeed]

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

[Reeza]

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

[touchspeed]

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

[Reeza · Accepted solution]

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.

[touchspeed]

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.

[Stewartli]

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.

  

[Stewartli]

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

http://documentation.sas.com/?docsetId=emref&docsetTarget=n0rzjozmp6um16n164o5w43nsaax.htm&docsetVer...