topic Re: Create freq table with 95%CI displaying three variables/columns using PROC SURVEYFREQ in SAS Programming

Create freq table with 95%CI displaying three variables/columns using PROC SURVEYFREQ

Barkat — Wed, 26 Oct 2022 22:11:27 GMT

I have a survey data. I need to create a table as below. I tried the following code, but it's not providing the expected table. Please help,

Please note, I have a variable called "Wt" as well for calculating weighted results.

Proc surveyfreq data= have;

table country*gender*result /cl ;

Weight Wt;

run;

Country	Gender	Result	Frequency	Weighted Freq.	Std. Err of Wgt Freq	Percent	Std Err of Percent	95% confidence limit for percent
A	Male	Positive
		Negative
	Female	Positive
		Negative
B	Male	Positive
		Negative
	Female	Positive
		Negative
C	Male	Positive
		Negative
	Female	Positive
		Negative

Re: Create freq table with 95%CI displaying three variables/columns using PROC SURVEYFREQ

ballardw — Thu, 27 Oct 2022 06:47:30 GMT

Without data and at least some description of what is need it is very hard to provide any concrete suggestions.

Since you are not providing any sample design information, sampling method, strata, cluster and such one question is why are you using Surveyfreq?

Re: Create freq table with 95%CI displaying three variables/columns using PROC SURVEYFREQ

Barkat — Thu, 27 Oct 2022 16:18:33 GMT

This is an example data. I am using Surveyfreq to get confidence limit.

data have;
input ID Country $ Gender $ Result $;
datalines;
1 A Male Positive
2 B Male Negative
3 C Female Negative
4 A Female Negative
5 B Male Positive
6 C Male Positive
7 A Female Positive
8 B Female Negative
9 B Male Positive
;

Data have; set have;
if Country="A" then Prob=0.0617;
if Country="B" then Prob=0.0300;
if Country="C" then Prob=0.0780;
Wt=1/Prob;
run;