topic Re: SAS Programming in New SAS User

SAS Programming

VinitvictorCorr — Tue, 17 Sep 2019 06:39:18 GMT

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

Can anyone please help me out ?

Re: SAS Programming

PeterClemmensen — Tue, 17 Sep 2019 06:53:45 GMT

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

Re: SAS Programming

VinitvictorCorr — Tue, 17 Sep 2019 07:09:05 GMT

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

Re: SAS Programming

PeterClemmensen — Tue, 17 Sep 2019 07:09:57 GMT

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

Re: SAS Programming

VinitvictorCorr — Tue, 17 Sep 2019 07:12:48 GMT

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

Re: SAS Programming

PeterClemmensen — Tue, 17 Sep 2019 07:15:10 GMT

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

Re: SAS Programming

VinitvictorCorr — Tue, 17 Sep 2019 07:16:56 GMT

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

Re: SAS Programming

PeterClemmensen — Tue, 17 Sep 2019 07:39:26 GMT

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;

Re: SAS Programming

VinitvictorCorr — Tue, 17 Sep 2019 10:04:31 GMT

this is perfect...thanks 🙂

Re: SAS Programming

PeterClemmensen — Tue, 17 Sep 2019 10:06:46 GMT

Anytime 🙂