topic Detect when numeric varible has all missing values in SAS Programming

Detect when numeric varible has all missing values

kalbo — Fri, 29 Oct 2021 14:27:31 GMT

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!

Re: Detect when numeric varible has all missing values

PaigeMiller — Fri, 29 Oct 2021 14:35:04 GMT

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.

Re: Detect when numeric varible has all missing values

Reeza — Fri, 29 Oct 2021 15:28:57 GMT

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

Re: Detect when numeric varible has all missing values

Tom — Fri, 29 Oct 2021 17:36:42 GMT

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.

Re: Detect when numeric varible has all missing values

mnatkins — Fri, 29 Oct 2021 18:58:05 GMT

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;