Export dataset from Sas E.Miner after a variable selection

[Mahmoud7]

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)

[Mahmoud7]

no one knows the answer ?

[WendyCzika]

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.