VDMML sas code node not affecting output data

Ullsokk — Wed, 01 Jul 2020 08:40:17 GMT

I have a simple code snippet I want to run in the SAS code node in VDMML, that removes varaibles with given suffixes. Here is my code:

proc contents noprint data=&dm_data out = contents (keep=name) ;
run;


data contents;
	set contents ;
	if index(lowcase(name),'_dt') then drop=1 ;
	if index(lowcase(name),'_rk') then drop=1 ;
	if index(lowcase(name),'_dttm') then drop=1 ;
run ; 
	
proc sql;
	select name into: dropvars separated by ' ' from contents where drop = 1;
	quit;

data &dm_data;
	set &dm_data (drop=&dropvars);
run;

The proc contents and SQL seems to work, and I get no errors in the log. The log even implies that the final dataset has 1602 variables, down 7 from the original 1609, just as expected. But the column is still there in the results view. And in the next node, the column is still visible, and populated with data.

Am I using the wrong macro variable name for the data? Do I need to do a CAS action? or do I have to do some metadata update?

Re: VDMML sas code node not affecting output data

Ullsokk — Wed, 01 Jul 2020 12:35:37 GMT

Figured out I could use the macro %dmcas_metaChange to change the role to rejected, as it seems variables cannot be dropped in the code node

topic VDMML sas code node not affecting output data in SAS Data Science

VDMML sas code node not affecting output data

Re: VDMML sas code node not affecting output data