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-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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
  • 1009 views
  • 0 likes
  • 2 in conversation