topic Re: Check Condition in multiple variables in SAS Programming

Check Condition in multiple variables

jay_bhavsar — Mon, 09 Aug 2021 12:13:42 GMT

Hello all,

I have below data

SUB	Arm	Screen	Week1	Week2	Week3	Week4	Week5	Week6	Week7	Week8	Week9	Week10	TIME TO ACHIVE TARGET 10
1	Test	8	8.2	8.4	8.6	8.8	9	9.2	9.4	9.6	9.8	10.1	10
2	Test	8.7	8.9	9.1	9.3	9.5	9.7	9.9	10.1	10.3	10.5	10.7	7
3	Ref	9	9.2	9.4	9.6	9.8	10	10.2	10.4	10.6	10.8	11	5
4	Test	9.5	9.7	9.9	10.1	10.3	10.5	10.7	10.9	11.1	11.3	11.5	3
5	Ref	9.8	10	10.2	10.4	10.6	10.8	11	11.2	11.4	11.6	11.8	1
6	Ref	10.3	10.5	10.7	10.9	11.1	11.3	11.5	11.7	11.9	12.1	12.3	-
7	Test	8	8.2	8.4	8.6	8.8	9	9.2	9.4	9.6	9.8	10	10
8	Ref	9.2	9.4	9.6	9.8	10	10.2	10.4	10.6	10.8	11	11.2	4
9	Ref	8.6	8.8	9	9.2	9.4	9.6	9.8	10	10.2	10.4	10.6	7
10	Test	8.3	8.5	8.7	8.9	9.1	9.3	9.5	9.7	9.9	10.1	10.3	9

i want to check that at which week subject has reached score of 10, in last column answer are there i want that column to be generated by coding if score is greater then 10 at screen we will drop that subject.

Thanks in advance.

Re: Check Condition in multiple variables

PaigeMiller — Mon, 09 Aug 2021 12:37:15 GMT

/* UNTESTED CODE */
data want;
    set have;
    if screen>10 then delete;
    array w week1-week10;
    array ww _temporary_;
    do i = 1 to dim(w);
         ww(i)=(w(i)>=10);
    end;
    time_to_achieve_target_10 = whichn(1,of ww[*]);
    drop i;
run;

If you want tested code, please provide data as a SAS data set (instructions)

Re: Check Condition in multiple variables

jay_bhavsar — Tue, 10 Aug 2021 05:18:21 GMT

Hi friend,
may be i failed to explain the query i run the the code but its not giving answer as i accepted. let me explain you the situation.
SUB 1 reached to score of more then 10 at week10 so "Time to achieve target 10" has value 10.
Likewise SUB 1 reached to score of more then 10 at week7 so "Time to achieve target 10" has value 7.
and for sub 3 its week5, for sub 4 its week3, for sub 5 its week1, for sub 7 its week10, for 8 week4 and so on.
and what if all Column name is not in sequence (Ex: Jan Mar May Sep Dec) then how can we get values of time to achieve target 10.

Re: Check Condition in multiple variables

andreas_lds — Tue, 10 Aug 2021 07:12:52 GMT

@jay_bhavsar wrote:
Hi friend,
may be i failed to explain the query i run the the code but its not giving answer as i accepted. let me explain you the situation.
SUB 1 reached to score of more then 10 at week10 so "Time to achieve target 10" has value 10.
Likewise SUB 1 reached to score of more then 10 at week7 so "Time to achieve target 10" has value 7.
and for sub 3 its week5, for sub 4 its week3, for sub 5 its week1, for sub 7 its week10, for 8 week4 and so on.
and what if all Column name is not in sequence (Ex: Jan Mar May Sep Dec) then how can we get values of time to achieve target 10.

There are no variables named "Jan", "Mar", etc in your data. Please post the data you have in usable form and with the variable names you have.

Please explain the role of the variables "Arm" and "Screen", are they necessary to calculate "TimeToAchieveTarget10"?

Untested:

data want;
  set have;
  length Target10 8;
  array values Week1-Week10;

  do i = 1 to dim(values);
    if values[i] >= 10 then do;
      Target10 = input(compress(vname(values[i]),,'kd'), 2.);
      leave;
    end;
  end;
run;

Re: Check Condition in multiple variables

jay_bhavsar — Tue, 10 Aug 2021 08:35:21 GMT

Thank you Andreas,

The code is giving desired results. One more thing to see what is some weeks in between are not there (file attached).

variables "Arm" and "Screen" is just for carry no need to check condition in that.

Re: Check Condition in multiple variables

andreas_lds — Tue, 10 Aug 2021 10:22:09 GMT

@jay_bhavsar wrote:

Thank you Andreas,

The code is giving desired results. One more thing to see what is some weeks in between are not there (file attached).

variables "Arm" and "Screen" is just for carry no need to check condition in that.

Sorry, but i won't open any office-file, please post the data in usable form.

Re: Check Condition in multiple variables

jay_bhavsar — Tue, 10 Aug 2021 12:15:04 GMT

which format is fine for you? SAS DATASET of any other??

Re: Check Condition in multiple variables

PaigeMiller — Tue, 10 Aug 2021 12:19:50 GMT

Earlier, I gave a link to instructions to provide your data as SAS data step code. That's the best form to use.

Re: Check Condition in multiple variables

jay_bhavsar — Wed, 11 Aug 2021 09:33:49 GMT

OK i am attaching file.

Re: Check Condition in multiple variables

PaigeMiller — Wed, 11 Aug 2021 10:11:19 GMT

Many of us will not download files. The SAS code should be included in your reply, as text by pasting it into the window that appears when you click on the "running man" icon.

Re: Check Condition in multiple variables

jay_bhavsar — Wed, 11 Aug 2021 10:20:40 GMT

data Have;
infile datalines ;
input SUB Arm $ Screen Week1 Week2 Week5 Week6 Week7 Week9 Week10 TIME_TO_ACHIVE_TARGET ;
datalines4;
1 Test 8 8.2 8.4 9 9.2 9.4 9.8 1 10
2 Test 8.7 8.9 9.1 9.7 9.9 1 5 7 7
3 Ref 9 9.2 9.4 10 2 4 8 11 5
4 Test 9.5 9.7 9.9 5 7 9 11.3 11.5 3
5 Ref 9.8 10 2 8 11 11.2 11.6 11.8 1
6 Ref 3 5 7 11.3 11.5 11.7 12.1 12.3 .
7 Test 8 8.2 8.4 9 9.2 9.4 9.8 10 10
8 Ref 9.2 9.4 9.6 2 4 6 11 11.2 4
9 Ref 8.6 8.8 9 9.6 9.8 10 4 6 7
10 Test 8.3 8.5 8.7 9.3 9.5 9.7 1 3 9
;;;;

Re: Check Condition in multiple variables

PaigeMiller — Wed, 11 Aug 2021 12:24:41 GMT

This data is dramatically different than what you posted originally, and there are many places where the value is 1 whereas before it was 10, which of course changes the results. Are these typographical errors?

Could you please correct all of your data set (or inform me that it already is correct)? Could you please post the code in a code box as I requested?

Re: Check Condition in multiple variables

jay_bhavsar — Wed, 11 Aug 2021 12:24:37 GMT

The posted data is same as before. the only difference is i removed some column to see how code can be apply when the sequence of Week1-Week10 is not there.
As for all available columns the code provided previously is working perfectly.

but i just curious to know what if we have columns which are not in sequence.

Re: Check Condition in multiple variables

PaigeMiller — Wed, 11 Aug 2021 12:42:40 GMT

The posted data is same as before.

No it is not.

There were 10s in the original data set, and the value of 1 appears now. Are these typographical errors? If so, please correct them.

Re: Check Condition in multiple variables

andreas_lds — Fri, 13 Aug 2021 04:34:50 GMT

Please explain why Time_To_Achieve_Target is 10 in the first line of the data you have posted. The maximum value is 9.8 in Week9.

The code i posted will need at one update if some week-variables don't exist. Changing the array-statement to

array values Week:;

should be sufficient, assuming that there are no variables in the dataset whose names start with "week" but must not considered in setting Time_To_Achieve_Target. And the variables must be properly sorted, if Week5 appears before Week4 the loop won't give the expected results.