Detect when numeric varible has all missing values

[kalbo]

Hi guys

I am trying to write simple code to check a numeric variable to see if it has all values missing or not and create a macro variable e.g ALLMISS=Y or N.

Any help would be appreciated.

e.g.

NUMVAR

.

.

.

Thanks!

[PaigeMiller]

proc summary data=have;
var numvar;
output out=counts n=n;
run;

If N=0 in the output data set named COUNTS, that's what you're looking for.

[Reeza]

https://gist.github.com/statgeek/feedc3fc520cb0d2018ca2a8cab241d8

[Tom]

Here is a pretty simple/quick way.

data _null_;
  if eof then call symputx('allmiss'='Y');
  set have(keep=numvar) end=eof;
  where not missing(numvar);
  call symputx('allmiss','N');
  stop;
run;

It will have to scan the whole file to get to YES but only up to the first non missing value to find that the answer is NO.

[mnatkins]

Another approach is to use Proc SQL:

proc sql  noprint;
    select case when sum(case when numvar is not null then 1 else 0 end) then 'N' else 'Y' end  into :allmiss
    from have;
quit;