topic Different Results Flag in SAS Programming

Different Results Flag

Ranjeeta — Fri, 24 Jan 2020 23:24:08 GMT

Would someone be able to explain what is the difference in terms of the sas data step processing with the flaf

I get different results with the same dataset

data NAC_D_6; set NAC_D_5;

array op[10] Main_Problem OTHER_PROBLEM_1 - OTHER_PROBLEM_9;

array opp[10] MAIN_PROBLEM_PREFIX OTHER_PROBLEM_PREFIX_1 - OTHER_PROBLEM_PREFIX_9;



flag_stroke_q=1;



do i=1 to 10;

      if substr(op[i],1,3) in: ('I63' 'I64' 'H341') and opp[i]~='Q' and substr(op[i],1,4)~='I636'

      then flag_stroke_q=0;

end;

drop i;

if flag_stroke_q=0;



run;

data NAC_D_6; set NAC_D_5;
array op[10] Main_Problem OTHER_PROBLEM_1 - OTHER_PROBLEM_9;
array opp[10] MAIN_PROBLEM_PREFIX OTHER_PROBLEM_PREFIX_1 - OTHER_PROBLEM_PREFIX_9;

flag_stroke_q=0;

do i=1 to 10;
	if substr(op[i],1,3) in: ('I63' 'I64' 'H341') and opp[i]='Q' and substr(op[i],1,4)~='I636'
	then flag_stroke_q+1;
end;
drop i;
if flag_stroke_q=0;

run;*

data NAC_D_6; set NAC_D_5;

array op[10] Main_Problem OTHER_PROBLEM_1 - OTHER_PROBLEM_9;

array opp[10] MAIN_PROBLEM_PREFIX OTHER_PROBLEM_PREFIX_1 - OTHER_PROBLEM_PREFIX_9;

flag_stroke_q=0;

do i=1 to 10;

if substr(op[i],1,3) in: ('I63' 'I64' 'H341') and opp[i]='Q' and substr(op[i],1,4)~='I636'

then flag_stroke_q+1;

end;

drop i;

if flag_stroke_q=0;

run;*

Re: Different Results Flag

ballardw — Sat, 25 Jan 2020 00:02:11 GMT

@Ranjeeta wrote:

Would someone be able to explain what is the difference in terms of the sas data step processing with the flaf

I get different results with the same dataset
data NAC_D_6; set NAC_D_5;

array op[10] Main_Problem OTHER_PROBLEM_1 - OTHER_PROBLEM_9;

array opp[10] MAIN_PROBLEM_PREFIX OTHER_PROBLEM_PREFIX_1 - OTHER_PROBLEM_PREFIX_9;



flag_stroke_q=1;



do i=1 to 10;

      if substr(op[i],1,3) in: ('I63' 'I64' 'H341') and opp[i]~='Q' and substr(op[i],1,4)~='I636'

      then flag_stroke_q=0;

end;

drop i;

if flag_stroke_q=0;



run;

data NAC_D_6; set NAC_D_5;
array op[10] Main_Problem OTHER_PROBLEM_1 - OTHER_PROBLEM_9;
array opp[10] MAIN_PROBLEM_PREFIX OTHER_PROBLEM_PREFIX_1 - OTHER_PROBLEM_PREFIX_9;

flag_stroke_q=0;

do i=1 to 10;
	if substr(op[i],1,3) in: ('I63' 'I64' 'H341') and opp[i]='Q' and substr(op[i],1,4)~='I636'
	then flag_stroke_q+1;
end;
drop i;
if flag_stroke_q=0;

run;*
data NAC_D_6; set NAC_D_5;

array op[10] Main_Problem OTHER_PROBLEM_1 - OTHER_PROBLEM_9;

array opp[10] MAIN_PROBLEM_PREFIX OTHER_PROBLEM_PREFIX_1 - OTHER_PROBLEM_PREFIX_9;

flag_stroke_q=0;

do i=1 to 10;

if substr(op[i],1,3) in: ('I63' 'I64' 'H341') and opp[i]='Q' and substr(op[i],1,4)~='I636'

then flag_stroke_q+1;

end;

drop i;

if flag_stroke_q=0;

run;*

When you use the code structure:

then flag_stroke_q+1;

Then you have told SAS the value of the variable FLAG_STROKE_Q is to be retained across observatation so you should be careful with that structure.

Here's an example of that feature:

data example;
   set sashelp.class;
   flag+1;
run;

Not an issue because you initialize the variable in each iteration, but be careful.

You start with a different value for your Flag variable before the DO loop in both cases, one only has the option of changing the flag to 0 and the other adds to the value of the each time a comparison is true.. So you create different values for the variable and then only keep the records when 0.

The first code would only have the record at least one of the conditions in the loop is true.

The second will keep the record only if ALL of the records have the comparisons as false.

Re: Different Results Flag

Astounding — Sat, 25 Jan 2020 15:16:46 GMT

Well, you ran two different programs against the same data. Is it a shock that the results are different?

Try removing this statement from both programs:

if flag_stroke_q=0;

Then you can look at the final values for FLAG_STROKE and see if they make sense to you.

On a side note, both programs get the wrong answer. SUBSTR and IN: are usually a bad mix. Remove the SUBSTR function. Otherwise, you will process "H34" instead of "H341".