I need help in SAS University Edition for questions 1b and 1c : * Question 1B ->

Question

I need help in SAS University Edition for questions 1b and 1c:

* Question 1B -> NumUnemploy1

* Question 1C

I have trouble understanding the relationship between the variables Age, Pop and Unemploy1, in order to create the variable NumUnemploy1.

We are asked to create a variable (NumUnemploy1), that contains the number of unemployed males in the 14-24 age group.

Let's say that:

Pop is the total of people by state in hundred thousands.

Age is the number of males in the 14-24 age per 1000 of total state population.

But, Unemploy1 does not refer to a number of people... instead it says "rate" of unemployment of urban males per 1000 in the age group of 14-24.  

So, my question is... what are the aritmetics that we need to apply in this case to create the variable "NumUnemploy1" ?

1. The data sets Crime 1960.1.txt and Crime1960.2.txt posted on Blackboard are tab delimited files containing data for 47 US statcs. They originally comc from the Uniform Crime Report of the FBI and other US government sources. The two data sets include the same observations, but while they share the Rate and Pop variables, all others appcar in only one of the two filcs. Rcad thesc data scts into SAS The variables in this data set are all related to the 1960 calendar year except for one: . Ratc: number of offences known to the policc pcr 1,000,000 population . Age: the number of males aged 14-24 per 1,000 of total state population. e South: Variablc indicating a southcrn statc if cqual to 1 Edu: mean number of years of schooling × 10 of the population, 25 years old and over. . PoExp60: per capita expenditure on police protection by state and local government in 1960. PoExp59: per capita expenditure on police protection by state and local government in 1959. LF: labor force participation rate per 1,000 civilian urban males in the age group 14-24 Pop: State population sizc in hundred thousands. . NonWhite: the number of nonwhites per 1,000 . Unemploy1: unemployment rate of urban males per 1,000 in the age group 14-24. . Unemploy2: unemployment rate of urban males per 1,000 in the age group 35-39 . Wealth: wealth as measured by the median value of transferable goods and assets or family income (unit 10 dollars) Inlneq: the number of families per 1,000 earning below one half of the median income (a) Create a SAS data set that merges the data from Crimel this SAS data set and report your output. (b) Add two variables to the data set. e DiffPoExp: The difference in per capita police expenditure between 1960 and 1959 NumUnenploy1: The number of unemployed males in the 14-24 age group. (Hint: Use Age, Pop, and Unemploy1 to do this) Print the resulting SAS data set and report your output. (c) Use subsetting to create a data set consisting only of states in the south. Print the resulting data sct and report your output.

Explanation / Answer

NumUnEmploy1 = (Pop * Age * 100) * Unemploy1 / 1000 = (Pop * Age * Unemploy1 / 10)

Explanation:

Pop is the State population size in hundred thousands. So, State Population Size = (Pop * 100,000)

Age is number of males aged 14-24 per 1,000 of state population. So, Number of Males aged 14-24 in state = (Pop * 100,000) * (Age / 1000) = (Pop * Age * 100)

Unemployment Rate normally means that percentage of the labor force that is unemployed. However, here it has been given as per thousand instead of per hundred (percent). Here, the entire population in the age group of 14-24 is employable.

So, Unemploy1 = (unemployed people in age group 14-24) / (people in age group 14-24) * 1000

But, unemployed people in age group 14-24 = NumUnEmploy1

So, NumUnEmploy1 = (Pop * Age * 100) * Unemploy1 / 1000 = (Pop * Age * Unemploy1 / 10)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.