proc tabulate for 95%CI intervals

[Cruise]

proc tabulate data=have order=internal;
var ob;
class agecat race1 ;
tables (All agecat race1 ), 
	   (N colpctn*f=5.1) ob*(mean*f=percent7.1 lclm uclm)/nocellmerge printmiss;
run; 

Hi guys, I'd like to calculate 95% CI in the proc tabulate output. However, the output doesn't make sense. Any hints for what I might be doing wrong here?

[SuryaKiran]

Please provide sample data if possible and your expected result.

Try using PROC UNIVARIATE instead.

[ballardw]

---

@Cruise wrote:

proc tabulate data=have order=internal;
var ob;
class agecat race1 ;
tables (All agecat race1 ), 
	   (N colpctn*f=5.1) ob*(mean*f=percent7.1 lclm uclm)/nocellmerge printmiss;
run; 

Hi guys, I'd like to calculate 95% CI in the proc tabulate output. However, the output doesn't make sense. Any hints for what I might be doing wrong here?

---

Describe what about that output "does not make sense".

By any chance did you want the confidence limits to show % signs? Use a format similar to the way you did means, though I suggest making it a bit wider and including a couple more decimal places

[Reeza · Accepted solution]

It works fine, you didn't apply any format to it, so it shows as decimals instead. 

Apply a percentage format and make sure it's long enough to show at least one decimal place.

---

@Cruise wrote:

proc tabulate data=have order=internal;
var ob;
class agecat race1 ;
tables (All agecat race1 ), 
	   (N colpctn*f=5.1) ob*(mean*f=percent7.1 lclm uclm)/nocellmerge printmiss;
run; 

Hi guys, I'd like to calculate 95% CI in the proc tabulate output. However, the output doesn't make sense. Any hints for what I might be doing wrong here?

---