data a;
input id $ x y z map sales;
cards;
001 2 . 9 . 1000
002 . . 2 . 3240
003 7 . 1 . .
004 3 . 6 . 2300
;
run;
Suppose I have a data with more than 40 columns/variables, and I am trying to deteck and remove the null(all missing value) columns(for example in data a, there are 2 null columns:'y' and 'map').
After removing the null columns, the new data will be:
data new;
id $ x z sales;
001 2 9 1000
002 . 2 3240
003 7 1 .
004 3 6 2300
楼主
