Enterprise Miner Time Series Prep Node: How to access the TSID map table from a CODE node

[raleighlinda]

Hello:

I am trying to write code for a SAS Code Node whose input is from A Time Series Preparation Node. I need to be able to map the TSID and the cross id variable for merging later.

I tried to use an example from GF 2012   http://support.sas.com/resources/papers/proceedings12/200-2012.pdf

page 8, appendix

data dataset1;

set &EM_IMPORT_TRANSACTION;

keep myvar _NAMEID_;

run;

I get errors like.

WARNING: The variable _NAMEID_ in the DROP, KEEP, or RENAME list has never been referenced.

Is there another macro variable that will give me access to the TSID map table?

Thanks

[raleighlinda · Accepted solution]

It's possible to merge the Time Series Prep & Time Series Similarity TSID output with the Time Series Exponential smoothing node TSID output. This allows the mapping of TSID and cross sectional variable.

I will post more details after our team's Data Shootout solution presentation at Analytics 2013

Linda

Team 20 OK State