Conditional processing

alpod87 — Mon, 12 Sep 2022 15:14:42 GMT

Hi!

I have 2 columns with ratings A-K. One column is "incoming" rating (IB) of a period and the other "outgoing" (OB).

I'm looking to create a new column based on several conditions:

0 if no change during the period

1 if moved up 1 class, 2 if moved up 2 classes etc

-1 if moved down 1 class, 2 if moved down 2 classes etc

How would one go about accomplishing this without creating one hundred case when lines?

Thank you very much 🙂

Re: Conditional processing

PaigeMiller — Mon, 12 Sep 2022 15:25:52 GMT

I'm looking to create a new column based on several conditions:

0 if no change during the period

1 if moved up 1 class, 2 if moved up 2 classes etc

-1 if moved down 1 class, 2 if moved down 2 classes etc

How would one go about accomplishing this without creating one hundred case when lines?

Create new variables where the letters A, B, ... K are replaced by numbers and then the moving up or moving down is computed by subtraction. You can use the RANK function to obtain the numerical equivalent of A, B, ... K in the ASCII collating sequence; that's all you need.

data want;
    set have;
    ib_rank=rank(ib);
    ob_rank=rank(ob);
    change=ob_rank-ib_rank;
run;

topic Conditional processing in SAS Programming

Conditional processing

Re: Conditional processing