topic Re: Dynamic dataset name as result of Extension Node in SAS Data Science

Dynamic dataset name as result of Extension Node

rmlmrmlm — Thu, 13 Oct 2016 20:54:49 GMT

I developed an extended node that simply merges N data sets in a final one, this one with a dynamic name, every time the node runs.

I want to connect this Extended Node to another node, a Meta Data node or a Input Data node, using the dynamic name.

How do I reference the data set created with a dynamic name in these next Nodes?

Am I right if i say it should be would a EM_ .... variable? Do I need a SAS Code Node in the middle?

Thank you very much!

Re: Dynamic dataset name as result of Extension Node

WendyCzika — Fri, 14 Oct 2016 17:09:34 GMT

I think all you want to do is call the data set &EM_EXPORT_TRAIN, then any subsequent nodes (connected to your extension node), will have that data set as the incoming training data set.

Re: Dynamic dataset name as result of Extension Node

rmlmrmlm — Sat, 15 Oct 2016 07:08:31 GMT

Hello Wendy Czika.

I think that's it!

My final code block, now, it's like this:

----------------------------------------------------------------------------------------------------

DATA final_client_dataset;

MERGE client_dataset_1 client_dataset_2 client_dataset_3;

BY client_id;

RUN;

----------------------------------------------------------------------------------------------------

What you say is to put another code block, something like this and the incoming node (for example a Metadata Node) will automatically use it?

----------------------------------------------------------------------------------------------------

DATA &EM_EXPORT_TRAIN;

SET final_client_data_set;

RUN;

----------------------------------------------------------------------------------------------------

Thank you very much! I'll try it next Monday.

Re: Dynamic dataset name as result of Extension Node

rmlmrmlm — Mon, 17 Oct 2016 08:05:22 GMT

Thank you! It works!