topic Re: a single if-then statement that applies to all variables in the dataset? in SAS Programming

a single if-then statement that applies to all variables in the dataset?

kai_cody — Thu, 11 Mar 2021 21:23:37 GMT

Hello,

I am trying to code all variables in my dataset so that any observations less than 0 are coded as missing.

I tried something like this, but I guess the "_ALL_" trick only works in certain situations and doesn't work here?

if _ALL_ < 0 then _ALL_=.;

Does anyone know of an easier way to get SAS to perform this data step all at once, without me having to list each variable on their own on a separate line?

Thank you!!!

Re: a single if-then statement that applies to all variables in the dataset?

PaigeMiller — Thu, 11 Mar 2021 21:28:15 GMT

I assume you have all numeric variables, as <0 doesn't apply to character variables. So ... the data step method you need is called an ARRAY.

data want;
    set have;
    array x _numeric_;
    do i=1 to dim(x);
        if x(i)<0 then call missing(x(i));
    end;
run;

Re: a single if-then statement that applies to all variables in the dataset?

Reeza — Thu, 11 Mar 2021 22:15:25 GMT

Your logic can also be reduced to the maximum of a series being less than 0. Note that rows of missing will evaluate as true and all will be set to missing, which is the same so a non-issue.

if max(of _numeric_) < 0 then call missing(of _numeric_);