Sas Assignment
UNSW SCHOOL OF MATHEMATICS MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS ASSIGNMENT 1 - ANSWERS TOTAL MARKS 20 (10% of final grade) Number of Questions: 2
The datafile contains data from the U.S. 1992 Census of Agriculture (Appendix C S. Lohr Sampling: Design and Analysis p437).
Column 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
1.
Name county state acres92 acres87 acres82 farms92 farms87 farms82 largef92 largef87 largef82 smallf92 smallf87 smallf82 region
Value county name state abbreviation number of acres devoted to farms, 1992 number of acres devoted to farms, 1987 number of acres devoted to farms, 1982 number of farms, 1992 number of farms, 1987 number of farms, 1982 number of farms with 1000 acres or more, 1992 number of farms with 1000 acres or more, 1987 number of farms with 1000 acres or more, 1982 number of farms with 9 acres or fewer, 1992 number of farms with 9 acres or fewer, 1987 number of farms with 9 acres or fewer, 1982 S = south, W = west, NC = north central, NE = northeast
[8marks] Create the SAS data, work.A1Q1 with the features described below from the SAS dataset agpop. a. Create the SAS data, work.A1Q1. b. Display only the variables region, county, state, acres92, and farms92. c. The data includes two subsets (i) the number of acres devoted to farms in 1992 (acres92) was between 32,000 and 100,000 in west region (‘W’). (ii) the number of acres devoted to farms in 1992 (acres92) is less than 50,000 in south region (‘S’). d. Use the labels below to replace the variable names. Variable acres92 farms92 Label Number of Acres Number of Farms
data work.A1Q1; set work.agpop; where (ACRES92 between 32000 and 100000 and region eq 'W') or
The datafile contains data from the U.S. 1992 Census of Agriculture (Appendix C S. Lohr Sampling: Design and Analysis p437).
Column 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
1.
Name county state acres92 acres87 acres82 farms92 farms87 farms82 largef92 largef87 largef82 smallf92 smallf87 smallf82 region
Value county name state abbreviation number of acres devoted to farms, 1992 number of acres devoted to farms, 1987 number of acres devoted to farms, 1982 number of farms, 1992 number of farms, 1987 number of farms, 1982 number of farms with 1000 acres or more, 1992 number of farms with 1000 acres or more, 1987 number of farms with 1000 acres or more, 1982 number of farms with 9 acres or fewer, 1992 number of farms with 9 acres or fewer, 1987 number of farms with 9 acres or fewer, 1982 S = south, W = west, NC = north central, NE = northeast
[8marks] Create the SAS data, work.A1Q1 with the features described below from the SAS dataset agpop. a. Create the SAS data, work.A1Q1. b. Display only the variables region, county, state, acres92, and farms92. c. The data includes two subsets (i) the number of acres devoted to farms in 1992 (acres92) was between 32,000 and 100,000 in west region (‘W’). (ii) the number of acres devoted to farms in 1992 (acres92) is less than 50,000 in south region (‘S’). d. Use the labels below to replace the variable names. Variable acres92 farms92 Label Number of Acres Number of Farms
data work.A1Q1; set work.agpop; where (ACRES92 between 32000 and 100000 and region eq 'W') or