topic Export dataset from Sas E.Miner after a variable selection in SAS Data Science

Export dataset from Sas E.Miner after a variable selection

Mahmoud7 — Mon, 22 Apr 2019 16:49:42 GMT

Hello,

I want to be able to export the modified dataset after the variable selection

when I used the varaible selection node, 71 variables were rejected from a total of 256 ones, so in order to do some statistical work on the remaining, I have used a SAS node trying to export the selected varaibles ONLY (185 varaibles),

My sas code was the following :

proc sql;

create table work.test as select a.*

from

&EM_IMPORT_DATA a;

run;

Any ideas how to do it, or for any result of other miner node (a transformation node for exemple)

Re: Export dataset from Sas E.Miner after a variable selection

Mahmoud7 — Wed, 24 Apr 2019 08:31:41 GMT

no one knows the answer ?

Re: Export dataset from Sas E.Miner after a variable selection

WendyCzika — Wed, 24 Apr 2019 13:24:13 GMT

I prefer DATA step to SQL, but there is probably a way to do it with SQL too 🙂

data work.test;
 set &em_import_data;
 drop %em_rejected;
run;

Note for this to work, you need to set the Hide Rejected Variables property in the Variable Selection node to No, then in the Variables editor for the SAS Code node, set Use=Yes for all variables.