topic Re: Re If and then in SAS Programming

Re If and then

anilgvdbm — Fri, 08 Feb 2019 11:22:54 GMT

Hi Experts,

I need a solution in if and then conditions for multiple variables.

I have data for 10 years and each year as one variable please find the example below

Cutomer ID	year1	year2	year3	year4	year5	year6	year7	year8	year9	year10	Tag
1	49	12	12	37	32	26	13	14	35	21
2	30	46	43	24	31	17	45	40	16	16
3	25	39	32	29	30	48	32	43	35	17
4	14	40	47	35	12	18	32	39	44	42
5	23	12	19	42	26	24	25	30	15	41

in the above table, i want to create tag as good, average and bad. how to use if and then for 10 variables at one go.

the conditions are if year1-year10 le 10 then Tag=good

else if year1-year10 le 10 then Tag=average;

else if year1-year10 le 10 then Tag=poor;

Request you all to suggest me how to do in otherways.

Regards.

Anil

Re: Re If and then

RW9 — Fri, 08 Feb 2019 11:55:06 GMT

I am afraid your logic does not make much sense:

"the conditions are if year1-year10 le 10 then Tag=good

else if year1-year10 le 10 then Tag=average;

else if year1-year10 le 10 then Tag=poor;"

This all means that if year1-10 is le 10 then tag should be good, average, and poor, as all are true if any value is less or equal to then 10.

I mean I can do the first if for you, but I don't see how the second two logical work:

Array method:

data want;
  set have;
  length flag $20;
  array year{10};
  do i=1 to 10;
    if year{i} <= 10 then flag="good";
  end;
run;

I would like to say use a function (corrected now, this is what happens when you overthink it!):

data want;
  set have;
  length flag $20;
  if min(of year:)<=10 then flag="good";
run;

Re: Re If and then

novinosrin — Fri, 08 Feb 2019 14:27:20 GMT

the conditions are if year1-year10 le 10 then Tag=good

else if year1-year10 le 10 then Tag=average;

else if year1-year10 le 10 then Tag=poor;

I can't understand the above

Re: Re If and then

ballardw — Fri, 08 Feb 2019 15:10:17 GMT

@anilgvdbm wrote:

Hi Experts,

I need a solution in if and then conditions for multiple variables.

I have data for 10 years and each year as one variable please find the example below

Cutomer ID year1 year2 year3 year4 year5 year6 year7 year8 year9 year10 Tag

1 49 12 12 37 32 26 13 14 35 21

2 30 46 43 24 31 17 45 40 16 16

3 25 39 32 29 30 48 32 43 35 17

4 14 40 47 35 12 18 32 39 44 42

5 23 12 19 42 26 24 25 30 15 41

in the above table, i want to create tag as good, average and bad. how to use if and then for 10 variables at one go.

the conditions are if year1-year10 le 10 then Tag=good

else if year1-year10 le 10 then Tag=average;

else if year1-year10 le 10 then Tag=poor;

Request you all to suggest me how to do in otherways.

Regards.

Anil

Your example data should include at least on case each of "good", "average" and "poor". And you should indicate to us which observation or row of data is which.

You rules in the if then are exactly the same for all three cases so makes little sense.

By year1-year10 do you mean "subtract year10 from year1", "all values of the variables year1 through year10", "any value of the variables year1 through year10" or something else. It is not very clear from your code or narrative which is intended.