Share for RTRA

Download the DOC version (DOC, 39.5 KB)

1. The RTRA Share procedure shows the relationship between two continuous variables. For example, this procedure can be used to calculate the Share of income to spending by sex. To generate a Share, call the following RTRA procedure:

%RTRAShare (
InputDataset=,
OutputName=,
ClassVarList=,
ShareOfVar=,
ByVar=,
UserWeight=);

2. %RTRAShare parameter definition:

InputDataset = identify the input data set from the WORK area to be used by the procedure.

OutputName= identify the output dataset name you want returned (maximum of 20 characters and the first character must not be an underscore).

ClassVarList = identify a maximum of four variables for the dimensions of the Share procedure. These variable needs to be delimited by a space or asterisk. Each variable must contain more than one but no more than 500 unique values. This parameter may be left empty if you wish to calculate Shares for the entire population.

NumeratorVar = identify exactly one variable as the numerator. This variable must be of type numeric.

DenominatorVar = identify exactly one variable as the denominator. This variable must be of type numeric.

ByVar = identify exactly one variable for the Share procedure. This variable must contain more than one but no more than 500 unique values.

UserWeight = refer to the RTRA parameters document to identify a survey weight. The weight variable identified will be merged onto the input data set using the ID variable.

3. Example: This procedure can be used to calculate the Share of total income over total number of hours worked, giving an hourly wage rate. You would like this Share calculated for each “Province”.

%RTRAShare (
InputDataset=work.LFS,
OutputName=Table1,
ClassVarList=,
ShareOfVar=Income,
ByVar=Province,
UserWeight=Finalwt);

The following table displays results from the example procedure above.

Table 1
Results from example procedure
Province _Share_ _Count_
    27268000
ON 0.0183 428000
QC 0.0041 115000
BC 0.028 784000
SK 0.021 628000
MB 0.197 6420000
AB 0.4 10580000
NS 0.036 955000
NL 0.034 806000
PEI 0.117 2839000
NB 0.149 3713000

The results in this table can be read as follows:

  • The total weighted population
  • associated with the calculation of this table is equal to 27,268,000.
  • Ontario’s share of total income in Canada is equal to 1.83 %. The weighted population associated with this calculation is equal to 428,000.
  • Quebec’s share of total income in Canada is equal to 0.41%. The weighted population associated with this calculation is equal to 115,000
  • ... etc.
Date modified: