topic Re: used multi go to in program in SAS Programming

used multi go to in program

mansour_ib_sas — Thu, 13 Jun 2019 12:13:35 GMT

Hello,

I want to use the go to following condition function.
Below an example.
the results of both functions is incorrect.
Could you, please, help me understand why?

Thank you

data info;
   input x;
   if 1<=x<=5 then do;
   go to eq1;
   return;    
  end;
   
   else do;
     if x > 6 then do;
     go to eq2;
     return;
     end;
   end;
   eq1: eq_x1=x;
   eq2: eq_x2=x;
  
   datalines;
7
6
323
2
5
;

Re: used multi go to in program

Kurt_Bremser — Thu, 13 Jun 2019 12:29:10 GMT

First, let's give this code some visual formatting so we can understand its structure (see Maxim 12):

data info;
input x;
if 1 <= x <= 5 then do;
  go to eq1;
  return;    
end;
else do;
  if x > 6 then do;
    go to eq2;
    return;
  end;
end;
eq1: eq_x1 = x;
eq2: eq_x2 = x;
datalines;
7
6
323
2
5
;

Next, it is important to keep in mind that go to is not like a subroutine call; everything after the targeted label will be executed. This means that every time the first option takes effect, both assignments will execute.

On top of that, if no condition is met, the execution will simply "fall through" and also execute both assignments.

Only in cases where x > 6 will the second assignment alone be executed.

What did you expect?

Hint from me:

In 20+ years of working with SAS, I have never (as in NEVER) had to use a go to. There may be cases where a %goto can be helpful, but a data step go to solves nothing IMO that does not have a much better, structured solution by using do/end blocks and while/until loops.

Re: used multi go to in program

Astounding — Thu, 13 Jun 2019 12:35:44 GMT

Is it possible you are overcomplicating things?

data info;
   input x;
   if 1<=x<=5 then eq_x1 = x;
   else if x > 6 then eq_x2 = x;
   datalines;
7
6
323
2
5
;

Re: used multi go to in program

mansour_ib_sas — Thu, 13 Jun 2019 13:17:56 GMT

I have dealt with a similar case.
I want to go find the difference between varc and Avc of E1 in E2.
for that, I take this difference in av of E2 when varC equal to 2 then the inputer in av of E1 to varc = 1

data HA;
input varA varB VarC qdT av avT;
cards;
AA E1 1 10 4  8
AA E1 3 10 4  8
AA E2 2 5  10 15 
AA E2 4 5  5  15
; run;

data WA;
input varA varB VarC qdT av avC;
cards;
AA E1 1 10 6  10
AA E1 3 10 4  10
AA E2 2 5  8  13 
AA E2 4 5  5  13
; run;


data HB;
input varA varB VarC qdT av avC;
cards;
AA E1 1 10 4  8
AA E1 3 10 4  8
AA E2 2 5  1  6 
AA E2 4 5  5  6
; run;


data WB;
input varA varB VarC qdT av avC;
cards;
AA E1 1 10 5  9
AA E1 3 10 4  9
AA E2 2 5  0  6 
AA E2 4 5  5  6
; run;

Re: used multi go to in program

Reeza — Thu, 13 Jun 2019 15:08:30 GMT

Is that your input data sets? All 4? From those demo data sets what do you expect as output?

Re: used multi go to in program

mansour_ib_sas — Thu, 13 Jun 2019 15:38:06 GMT

HA is input and WA output expect

HB is input and WB output expect

Re: used multi go to in program

Astounding — Fri, 14 Jun 2019 16:10:21 GMT

It has been a couple of days, and I still haven't figured out the calculations.

How do you get from HA to WA (and from HB to WB)? I don't need programming statements, I need to see that logic that you use and where the numbers come from.

Re: used multi go to in program

ballardw — Fri, 14 Jun 2019 22:14:36 GMT

@mansour_ib_sas wrote:

HA is input and WA output expect

HB is input and WB output expect

Your statements:

I want to go find the difference between varc and Avc of E1 in E2.
for that, I take this difference in av of E2 when varC equal to 2 then the inputer in av of E1 to varc = 1

Appear to be comparing variables in different data sets since AVC is NOT in HA (input) where does the value of AVC come from that is compared with VARC to get a difference???