Calcite | Level 5

Activity, employment, unemployment, inactivity

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

Super User

Re: Activity, employment, unemployment, inactivity

@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.

Discussion stats