topic Exporting and Replacing a SAS Data File for Use in EG From EM in SAS Data Science

Exporting and Replacing a SAS Data File for Use in EG From EM

Zachary — Mon, 24 Nov 2014 14:59:33 GMT

Please view the following basic code that I put into a SAS Code Node within Enterprise Miner:

%let EXPORT_DIR_NAME = \\SAS01\sasusers\Shared\PredictiveModeling;
%let EXPORT_TABLE_NAME = ExportedContinuousData;

libname export "&EXPORT_DIR_NAME";

data export.&EXPORT_TABLE_NAME.;
set &EM_IMPORT_DATA;
keep _NODE_ P_BLEND_GROSS_LOAD V_BLEND_GROSS_LOAD BLEND_GROSS_LOAD PURE_PREMIUM COST_CENTER_ID;
replace;
run;

It worked perfectly before I had the line saying replace in there, but now it just will not work.

Thank you very much in advance.

Message was edited by: Communities Admin (removed email and phone for security reasons)

Re: Exporting and Replacing a SAS Data File for Use in EG From EM

art297 — Mon, 24 Nov 2014 15:07:33 GMT

The REPLACE statement can appear only in a DATA step that contains a MODIFY statement

Re: Exporting and Replacing a SAS Data File for Use in EG From EM

Zachary — Mon, 24 Nov 2014 16:24:33 GMT

Thank you. Do you have an example handy of the modify command? Or would you suggest doing it outside of the DATA step?

Re: Exporting and Replacing a SAS Data File for Use in EG From EM

M_Maldonado — Mon, 24 Nov 2014 16:30:43 GMT

I googled an example. It seems that you should use a modify statement instead of a set statement.

SAS Replace Statement

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201991.htm

Zach, why do you need to use a replace statement in your SAS Code Node? This code would re-run every time you run that path on your EM diagram, wouldn't it?

I hope it helps,

Miguel

Re: Exporting and Replacing a SAS Data File for Use in EG From EM

art297 — Mon, 24 Nov 2014 16:32:32 GMT

Since all you are doing is saving a copy of an existing SAS dataset, simply remove the line that contains the replace statement. You simply shouldn't use a replace statement for what you are trying to do.

However, since you asked, the documentation about it can be found at: SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition