topic Re: How can use Loop to operation ? in SAS Programming

How can use Loop to operation ?

yuwentaiwan — Fri, 17 Apr 2020 08:57:26 GMT

Good afternoon fellow SAS users and the overall SAS community.

oba f se

1 7/30

2 5/30

3 9/30

4 11/30

5 21/30

SE=f*(1-f)/5,

How can use loop to operation all SE?

Thank you!!

Re: How can use Loop to operation ?

Jagadishkatam — Fri, 17 Apr 2020 09:19:19 GMT

Hope this is what you are expecting

data have;
input oba f$;
cards;
1 7/30 
2 5/30
3 9/30
4 11/30
5 21/30
;

data want;
set have;
numerator=input(scan(f,1,'/'),best.);
denominator=input(scan(f,2,'/'),best.);
nd=numerator/denominator;
SE=nd*(1-nd)/5;
run;

Re: How can use Loop to operation ?

Tom — Fri, 17 Apr 2020 17:20:57 GMT

Do you actually have that "F" value as the strings you are showing? Or do you have two numeric variables?

Re: How can use Loop to operation ?

ChrisNZ — Fri, 17 Apr 2020 22:32:28 GMT

For the values you have, @Tom 's reply is probably the best way.

For a generic calculation, here is another way:

data HAVE;
input OBA F $20.;
cards;
1 7/30+4/3
2 5/30
3 9/30
4 11/30
5 21/30-23/16+5/8
;

data WANT;
  set HAVE;
  F1=input(resolve('%sysevalf('||F||')'),32.); putlog F1= ;
  SE=F1*(1-F1)/5;
run;

F1=1.5666666667

F1=0.1666666667

F1=0.3

F1=0.3666666667

F1=-0.1125