BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi everyone-

I have two datasets in which I need to use proc surveyfreq for
analysis. From one dataset, I want to use the row prevalence (and
confidence intervals) from the weighted frequency from the cross tab
and apply it to the weighted frequency of another cross tab (same
variables) from another dataset. I cannot figure out the coding to do
so. I believe I need to output new datasets and then merge them.

Here is an example of what I am looking for:

From one dataset-looking for disease prevalence:

Proc surveyfreq data=set1;
cluster=XXX;
strata=xxx;
tables age*gender*race*income*dis/row cl;
weight wt1;
run;

This will give me the percentage (and CI) of diseased within each
cross tab.

From another dataset-looking for group to apply disease percentage:

Proc surveufreq data=set2;
cluster=xxx;
strata=xxx;
tables area*age*gender*race*income/row cl;
weight wt2;
run;

This will give me the cross tab with weighted frequency of the number
of people within each area of interest. This is what I want to apply
the disease prevalence (and CI) to.

My hope is to be able to present the final data as the number of
diseased by age, gender, race and income for each respective area.

Any help would be tremendous.

Thanks to everyone in advance.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 0 replies
  • 531 views
  • 0 likes
  • 1 in conversation