标题: how to remove null columns [打印本页] 作者: shiyiming 时间: 2013-10-24 22:43 标题: how to remove null columns 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
Thanks a lot!!!!作者: shiyiming 时间: 2013-10-26 03:23 标题: Re: how to remove null columns %DROPMISS MACRO作者: shiyiming 时间: 2013-10-31 07:52 标题: Re: how to remove null columns nice, thanks a lot!