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

[kai_cody]

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!!!

[PaigeMiller · Accepted solution]

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;

[Reeza]

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_);