SAS Programming

[VinitvictorCorr]

i need to find a list of variables with all missing values in a dataset.

Can anyone please help me out ?

[PeterClemmensen]

What do you want to do with those variables? Drop them, put them in a data set or something third?

[VinitvictorCorr]

lets say drop them.. list of these variables is important to me

[PeterClemmensen]

Are the variables of interest all numeric, character or a mix of the two?

[VinitvictorCorr]

mixed..i would also love to know which are character and which are numeric. But i can get a list of that from sashelp.vcolumn.. so the emphasis is on missing variables

[PeterClemmensen · Accepted solution]

Ok. There are several ways to do this. But here is one:

Sample 24622: Drop variables from a SAS® data set whose values are all missing

[VinitvictorCorr]

Thank You:)... but is there any other way past arrays:P

[PeterClemmensen]

Sure thing 🙂

data have;
input var1 var2 var3 $ var4 $;
datalines;
1 . A .
. . B .
3 . . .
;

ods output nlevels=nlvs(where=(nnonmisslevels eq 0));
proc freq data=have nlevels;
    ods select nlevels;
run;

proc sql noprint;
    select tablevar into :drop separated by ' '  from nlvs;
quit;

data want;
    set have(drop=&drop);
run;

[VinitvictorCorr]

this is perfect...thanks 🙂

[PeterClemmensen]

Anytime 🙂