Delete columns with for loop
Hi, I create a for loop script to delete empty column (column contains only N/A).It works ok except on one file, one column get deleted when it's not suppose to.Not sure what's wrong for (i= ncols (dt[d]),i>=1,i--,
summarize(data table(dt[d]),temp = by(column(i)));
if(nitems(temp) ==1 & temp[1]=="N/A",
data table(dt[d])<< delete columns(column(i));
);
);