BookmarkSubscribeRSS Feed
Anabel
Calcite | Level 5

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

1 REPLY 1
ballardw
Super User

@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: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is ANOVA?

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.

Discussion stats
  • 1 reply
  • 1218 views
  • 0 likes
  • 2 in conversation