BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
monsieur
Obsidian | Level 7

Hi everyone,

 

I've been trying to create a function using PROC FCMP which will return a confidence interval (CI) using Wilson method. I would like to use the CI directly in a DATA step or PROC SQL. Here is the function : 

  

proc fcmp outlib = work.funcs.CI;

function CI_Wilson(r,n,output $,fmt,alpha) $;
    /* Define some values */
	p = r/n;
	q = 1 - p;
    z = probit(1-alpha/2);
	/* CI Wilson */
   	lower = (2*r+z**2-(z*sqrt(z**2+4*r*q)))/(2*(n+z**2));
    upper = (2*r+z**2+(z*sqrt(z**2+4*r*q)))/(2*(n+z**2));        
	/* CI */
	if output = "proportion" then ci = strip(put(r,10.)) || " " || strip(put(p,10.4)) || "(" || strip(put(lower,10.4)) || "-" || strip(put(upper,10.4)) || ")";
	else if output = "percent" then ci = strip(put(r,10.)) || " " || strip(put(p*100,10.4)) || "(" || strip(put(lower*100,10.4)) || "-" || strip(put(upper*100,10.4)) || ")";
	return(ci);
endsub;

quit;

options cmplib = work.funcs;
data _null_;
	ci_proportion = CI_Wilson(81,263,"proportion",10.4,0.05);
	ci_percent = CI_Wilson(81,263,"percent",10.4,0.05);
	put ci_proportion;
	put ci_percent;
run;

 It works fine if I write directly 

strip(put(p,10.4))

but SAS will give me error if I try

strip(put(p,fmt))
ERROR 22-322: Expecting a format name.
ERROR 202-322: The option or parameter is not recognized and will be ignored.

 

Furthermore, I already wrote a similar macro using DOSUBL and it worked fine with "fmt" as a macro variable. I just think for a simple calculation like this, it would be faster using PROC FCMP. If someone can suggest a solution, it would be greatly appreciated !!!

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
2 REPLIES 2
FriedEgg
SAS Employee

You need to use the putn function, not put.

monsieur
Obsidian | Level 7
Thank you FriedEgg, it works like a champ.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1374 views
  • 0 likes
  • 2 in conversation