topic Re: SAS Code Node in SAS Data Science

SAS Code Node

omerzeybek — Tue, 23 Dec 2014 06:42:56 GMT

Hi i have a plenty of regressors and their transformed versions. I just wanto check cross correlations between them. However i am unable to find a proper way to do it on SAS Miner, so i am trying to import my data to SAS EG.

However i have a problem with SAS Code Node, the node which i try to write a copy of table containing regressors to my database library

But think i am making a mistake on coding.

On training code section of SAS i am inserting the following code

DATA CRM.OZ_SUS_EXPORT_TRANS;

Set &EMWS1.STAT_TRAIN;

Run;

here Crm.OZ_SUS_EXPORT_TRANS table is the table which i want to create on database

EMWS1.STAT_TRAIN is the training data exported from my latest sas miner node

when i run this code i am recevining a run time error

could you please help on what has worked worng

Re: SAS Code Node

mohamed_zaki — Tue, 23 Dec 2014 07:35:13 GMT

In the the train code from code editor you have two run options: run node or run code

Try run code and attach the log.

zaki

Re: SAS Code Node

omerzeybek — Tue, 23 Dec 2014 07:41:00 GMT

Hi Mohamed

When i run the node i receive following error log text.

Thank you very much

14393 title10;

14394 %let EMEXCEPTIONSTRING=;

14395 %let syscc = 0;

PERFORMANCE DETAILS

15876 *------------------------------------------------------------*;

15877 * EMCODE: Generation of macros and macro variables;

15878 * To see the code generated, set the EM_DEBUG macro variable to SOURCE or _ALL_;

15879 *------------------------------------------------------------*;

15880 %let syscc = 0;

15881 %inc "/sasdata/EMiner/Pegasus_Model_V_Son/Workspaces/EMWS1/EMCODE/EMTRAINCODE.sas";

NOTE: %INCLUDE (level 1) file /sasdata/EMiner/Pegasus_Model_V_Son/Workspaces/EMWS1/EMCODE/EMTRAINCODE.sas is file /sasdata/EMiner/Pegasus_Model_V_Son/Workspaces/EMWS1/EMCODE/EMTRAINCODE.sas.

15882 +DATA EMWS1.STAT_TRAIN;

15883 +Set &CRM.OZ_PEGASUS_EXPORT_TRANS;

200

WARNING: Apparent symbolic reference CRM not resolved.

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, END, INDSNAME, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

15884 +Run;

14393 title10;

14394 %let EMEXCEPTIONSTRING=;

14395 %let syscc = 0;

PERFORMANCE DETAILS

15876 *------------------------------------------------------------*;

15877 * EMCODE: Generation of macros and macro variables;

15878 * To see the code generated, set the EM_DEBUG macro variable to SOURCE or _ALL_;

15879 *------------------------------------------------------------*;

15880 %let syscc = 0;

15881 %inc "/sasdata/EMiner/Pegasus_Model_V_Son/Workspaces/EMWS1/EMCODE/EMTRAINCODE.sas";

NOTE: %INCLUDE (level 1) file /sasdata/EMiner/Pegasus_Model_V_Son/Workspaces/EMWS1/EMCODE/EMTRAINCODE.sas is file /sasdata/EMiner/Pegasus_Model_V_Son/Workspaces/EMWS1/EMCODE/EMTRAINCODE.sas.

15882 +DATA EMWS1.STAT_TRAIN;

15883 +Set &CRM.OZ_PEGASUS_EXPORT_TRANS;

200

WARNING: Apparent symbolic reference CRM not resolved.

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, END, INDSNAME, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

15884 +Run;

Re: SAS Code Node

mohamed_zaki — Tue, 23 Dec 2014 07:54:25 GMT

15882 +DATA EMWS1.STAT_TRAIN;

15883 +Set &CRM.OZ_PEGASUS_EXPORT_TRANS;

200

WARNING: Apparent symbolic reference CRM not resolved.

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, END, INDSNAME, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

15884 +Run;

I think you entered it wrong

It is, as you mentioned previously right ?

Message was edited by: mohamed zaki

Re: SAS Code Node

SusanHaller — Wed, 24 Dec 2014 07:22:13 GMT

I believe your problem is an extra "&" that should not be present in your set statement. Your code is failing because it believes that EMWS1 is a macro that needs to be resolved, not a libname.

Try the following which should run successfully:

DATA CRM.OZ_SUS_EXPORT_TRANS;

Set EMWS1.STAT_TRAIN;

Run;

In addition, I wanted to point out the Save Data node available within EM under the Utility tab. This node was designed to do exactly what you are trying to do via the SAS Code node and it takes the responsibility of writing the code off of the user. This node allows you to save any of the output tables from a previous node into a predefined library.

To use the Save Data node in this example, if the CRM library has been initialized, you simply need to point to this using the SAS Library Name property within the node, set All Roles=No and specify Train=Yes under the Select Roles property. This will automatically save a copy of the STAT_TRAIN table to your CRM library.

Re: SAS Code Node

naveen_srini — Wed, 24 Dec 2014 07:56:45 GMT

Susanhaller's post makes complete sense as SAS understands that as &libref..datasetname, and typically the & macro trigger would be passed to the macro processor by the word scanner to look for the value to resolve to that is stored in the global symbol table and then place the resolved code in the input stack. In your case, it is apparent there is no mention of the macro variable being created at any point before. Therefore, that simple change should work unless there are other issues.

Re: SAS Code Node

omerzeybek — Thu, 01 Jan 2015 19:14:19 GMT

thank you very much . This has worked on me

Re: SAS Code Node

CharlotteCain — Thu, 01 Jan 2015 19:21:18 GMT

Please mark this question as answered and if you wish give them gift of points who helped you as they deserve some appreciation.

Thanks,

Charlotte

Re: SAS Code Node

omerzeybek — Thu, 01 Jan 2015 20:13:33 GMT

sorry i didnt know that awards has a real point

i have closed the inqury with correct answer badge

Thank you for tip