topic Re: If-Then is not working in SAS Programming

If-Then is not working

lansoprazole — Tue, 28 Sep 2021 12:04:59 GMT

Hi,

I am trying to create a random number and then assign it to a group according to its value.

I used very simple if-then, but it did not work!

this is my code:

data ranpatients;
seed=6789;
do i=1 to 40;
x1=int(ranuni(seed)*10000);
x=put(x1,z4.);
output;
end;
if x1 gt 5000 then group = "A"; else group = "B";
run;

When I run it, I have empty group column.

Any explanation ?

Thanks,

Re: If-Then is not working

PaigeMiller — Tue, 28 Sep 2021 12:15:21 GMT

The IF statement has to go before the OUTPUT statement.

Otherwise (the way you have it), the record is output to the data set RANPATIENTS before GROUP is assigned a value, so GROUP is always missing.

Re: If-Then is not working

Tom — Tue, 28 Sep 2021 12:38:27 GMT

The order of statements is wrong.

You have implemented an algorithm that is similar to:

Write letter.
Mail letter.
Apply stamp to letter.

It is hard to put the stamp on the letter after it is already in mailbox.

data ranpatients;
  seed=6789;
  do i=1 to 40;
    x1=int(ranuni(seed)*10000);
    x=put(x1,z4.);
    if x1 gt 5000 then group = "A"; else group = "B";
    output;
  end;
run;

Re: If-Then is not working

Kurt_Bremser — Tue, 28 Sep 2021 12:46:19 GMT

Apart from moving the IF, you should also consider using the more modern (and recommended) RAND function:

data ranpatients;
call streaminit(6789);
do i = 1 to 40;
  x1 = rand("integer",1,9999);
  if x1 gt 5000 then group = "A"; else group = "B";
  x = put(x1,z4.);
  output;
end;
run;

Re: If-Then is not working

lansoprazole — Tue, 28 Sep 2021 13:57:05 GMT

Thanks.

I tried it but the first observation (raw) was not assigned any group.

I will try it again.

Re: If-Then is not working

lansoprazole — Tue, 28 Sep 2021 13:58:37 GMT

Thanks.
so output should be always at the end? or because I am using a variable from the loop?

Re: If-Then is not working

PaigeMiller — Tue, 28 Sep 2021 14:02:05 GMT

@lansoprazole wrote:
Thanks.

I tried it but the first observation (raw) was not assigned any group.

I will try it again.

I tried it too, and group is assigned to every observation in the data set. If it is not working for you, SHOW US the code.

Re: If-Then is not working

Tom — Tue, 28 Sep 2021 14:03:12 GMT

If a data step dos not have an explicit OUTPUT statements then SAS will automatically OUTPUT (write the current values to the saved dataset) at the end of the step.

But your code has an OUTPUT statement so there is no extra output added.

If you want the value of GROUP to depend on the value of X you have to calculate GROUP before you write the data to the file.

Re: If-Then is not working

lansoprazole — Tue, 28 Sep 2021 14:03:59 GMT

It works now. I had to restart SAS

Re: If-Then is not working

PaigeMiller — Tue, 28 Sep 2021 14:04:12 GMT

@lansoprazole wrote:
Thanks.
so output should be always at the end? or because I am using a variable from the loop?

I don't know if it should ALWAYS be at the end, as there may be examples where OUTPUT is not at the end.

What you are being advised to do is assign the value of GROUP before the OUTPUT.

Re: If-Then is not working

Ron_Cody — Tue, 28 Sep 2021 14:31:48 GMT

Hi.

I see you are using the RANUNI function. Take a look at the RAND function that replaces EVERY previous random function. You set the seed with "Call Streaminit(seed);" and to get uniform random numbers, you use "Variable = rand('Uniform');". The beauty of this function is that by changing the first argument you can generate normal, Bernoulli, Poisson, etc. You can also set a mean and standard deviation for normal distributions. Take a look. I think you will like this function. SAS recommends it and says it generates "better" random strings.