These data were collected as part of a survey by the Lake Agassiz Arts Council in 1994. A copy of the actual survey questions is included as a pdf with this assignment. The codebook for this data file is provided below. Using the codebook and the actual survey, write a SAS data step that reads in the variables that allow you to answer the questions below. For items with only one choice like Age Group, the codes are numbered from left to right (so age is coded from 1 through 6 since there are 6 choices). Note that for ‘Check All That Apply Items’, one means checked and zero means not checked. For Item 9, 1 means a response was given and zero means no response was provided.
VARIABLE LOCATION TYPE
-------- -------- ----
ID ..................... 1- 3 Character
Heritage ............... 5 Character or Numeric
Age Group .............. 6 Character or Numeric
Gender ................. 7 Character or Numeric
Special Needs........... 8 Character or Numeric
City ................... 9 Character or Numeric
Item 1 Choices Row 1 ... 12-16 Character or Numeric
Item 1 Choices Row 2 ... 18-22 Character or Numeric
Item 1 Choices Row 3 ... 24-28 Character or Numeric
Item 2 Choices Row 1 ... 31-34 Character or Numeric
Item 2 Choices Row 2 ... 36-39 Character or Numeric
Item 2 Choices Row 3 ... 41-44 Character or Numeric
Item 2 Choices Row 4 ... 45-48 Character or Numeric
Item 3 Choices Row 1 ... 50-54 Character or Numeric
Item 3 Choices Row 2 ... 56-59 Character or Numeric
Item 4 Choices Row 1 ... 62-65 Character or Numeric
Item 4 Choices Row 2 ... 67-70 Character or Numeric
Item 4 Choices Row 3 ... 72-73 Character or Numeric
Item 5 Choices Row 1 ... 76-79 Character or Numeric
Item 5 Choices Row 2 ... 81-85 Character or Numeric
Item 5 Choices Row 3 ... 87-88 Character or Numeric
Item 6 ................. 91 Character or Numeric
Item 7 ................. 92 Character or Numeric
Item 8 ................. 93 Character or Numeric
Item 9 ................. 94 Character or Numeric
laacx.txt (note all 94 columns are shown):
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...
001 342.2 11100 00001 01100 0111 1001 110 110 00000 0110 0000 0010 00 0000 00100 00 2150
a) Identify the scales of measurement for the 4 variables below and explain your answer for each.
* Heritage * Age Group * Item 6 * Item 8
b) Create a user-defined format for Heritage that has only the two levels: 3='European American' and all non-missing codes = 'Other'.
Create a user-defined format for age with these age groups: 12-23, 24-39, 40-55, 56-70+. Note that the original categories are numbered from 1 to 6 where 1 represents the 12-18 age group and 6 the 70+ age group.
Create a user defined format for question 8 that has the levels <=$10 (combine <$5 and $5-$10), $10-$20 (combine $10-$15 and $15-$20), and >$20. The original codes are: 1='< $5' 2='$5-$10' 3='$10-$15' 4='$15-$20' 5='> $20. Any other codes should be grouped into an 'Invalid Response' category.
Use the above formats and summarize the results in one-way tables for the 5 demographic questions (Heritage through City). Comment on what you see.
c) Based upon Item 6, how important were arts and cultural activities to survey respondents?
d) Based upon Item 8, are respondents willing to invest money in attending arts and cultural events? I have a working hypothesis that Fargo residents were willing to spend more money on arts and cultural events than the residents of the other cities. Do the data appear to support this?
e) One of the choices in Item 5 is Live Theater. What percentage of respondents indicated an interest in attending live theater events? Is this percentage consistent across Age groups? Be sure to use the user defined format you created in b) when answering.
f) Create a new variable that counts how many of the choices for Item 1 were checked by each survey respondent. Similarly, create a new variable to count the number of choices checked by each respondent for Item 2. Describe / illustrate the distributions for both of these new variables.
g) Item 3 could be called ‘Barriers’ to attending arts and cultural events. Which barriers seem to be the most important? An effective presentation of the answer here would include a ranking of the choices from most common to least common. This can be accomplished by running multiple simple tables and manually ordering them (which is inefficient). We can use the idea of multivariate to univariate data structure conversion to get SAS to produce a single table with the frequencies. This would be the preferred solution and one that you should try to implement.
h) Item 5 lists choices for arts events – this was an important question for the client as it would allow them to target events that were most likely to be successful in the community. Pretend that you are the consultant hired by the client to answer this question and present the results with suggestions helpful to the client.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
