Hello,
I'm calculating rates of employment,activity, unemployment and inactivity by sex, age, nacionality, etc.
I'm doing the proces with de proc surveyfreq, the point is that I need diferente totals for each table, for example: for employment is the total of employment/total of population, but for unemployment is the total of unemployment/total of active people.
I can get the results in two proc surveyfreq and then link the tables, or there are an another way to be more eficient?
Thank you,
Virginia
@Anabel wrote:
Hello,
I'm calculating rates of employment,activity, unemployment and inactivity by sex, age, nacionality, etc.
I'm doing the proces with de proc surveyfreq, the point is that I need diferente totals for each table, for example: for employment is the total of employment/total of population, but for unemployment is the total of unemployment/total of active people.
I can get the results in two proc surveyfreq and then link the tables, or there are an another way to be more eficient?
Thank you,
Virginia
Show the code you are currently using.
If possible show an example of the output and what you want as output.
Also when you say "total" it might help to describe what you actually mean, as in example data and which are totals.
Note that a single call to proc surveyfreq can request multiple tables and there may be output options to request what you want.
And example tables statement from one of my projects:
tables bmitile *(z_decay z_decay4 z_fill z_df z_denthist z_alltreat z_resnone z_researly z_resurgent z_Seal ) /cv nowt nototal nocellpercent nostd
row cl chisq1 wchisq lrchisq1; ;
Requests cross tabulations of the BMITILE variable with 10 variables and suppresses some of the total and percentage results and request additional tests.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.