• You must complete the assignment by yourself. Exchanging ideas with classmates is encouraged, but you must not cross the line between discussion and collaboration. Showing your work to your classmates will be considered a kind of collaboration.
• Complete all tasks. Put all your SAS code into one PDF file. You must mark each question’s answer in the form of SAS comment statements in the code, such as /*Task 1*/. Name your code file as nnnnnnnn.pdf where nnnnnnnn is your student number.
• You should set all irrelevant statements in your code as SAS comment statements. Be aware that if you create your SAS code under a non-English operating system, it may contain extraneous characters when viewed in an English operating system. You are responsible for ensuring that your submitted code in the PDF file is free of these characters. All extraneous characters in your submitted code will be considered errors.
• When running in SAS Studio, your submitted SAS code should be free of error.
• You must submit your code file via the link Assignment 2 under the Assignments section of the course on Canvas. If you submit your file more than once, only the latest submitted file will be marked. The link will be closed on 30 November 2022 at 11:59 pm. Late submissions will not be accepted. Submission by other methods will not be accepted.
Download the zipped file Assignment2_Data.zip from the folder Assignments under Files | Assignments. Expand the zipped file for the following data sets and then upload them to your SAS Studio account (keep the data set names in lowercase when uploading):
• Broadband_Subscribers.sas7bdat
• Accounts.sas7bdat
You must use only the DATA steps or/and the PROCs included in Chapters 1-4 as needed to accomplish these tasks. Using other SAS procedures that are not included in Chapters 1- 4 will be considered errors.
Task 1:
Define a SAS Library named ‘xxxxxxxx’ for the folder that contains SAS data sets Broadband_Subscribers and Accounts in your SAS Studio account, where ‘xxxxxxxx’ is your given name. Use only the first eight letters of your given name if your given name is longer than 8 characters. For example, if your name is CHEN Da Wen, the library name should be ‘dawen’.
Task 2:
The SAS data set Accounts contains the billing amount (Amount_ToPay) in each month between January 2011 and December 2011 for each billing account (Bill_Account) in the format of one observation for each month (Bill_Mth) of each account. Some accounts may have less than 12 observations in the data set. Create a new SAS data set that contains the following characteristics:
• Name the new data set Bills_Jul_Dec and keep the data set in the Work library of SAS Studio.
• Keep only one observation for each billing account in Bills_Jul_Dec.
• Each observation in Bills_Jul_Dec contains variables Bill_7, Bill_8 …, and Bill_12 for the billing amount in each month from July 2011 to December 2011, respectively. If a billing account has nothing to pay in a particular month or no observation for a particular month, the respective amount to pay for that month will be 0.
• Each observation in Bills_Jul_Dec contains variable total billing amount (Bill_Total). The total billing amount for each observation equals the sum of monthly billing amounts between July 2011 and December 2011.
• Keep only these variables in Bill_Jul_Dec: Bill_Account, Bill_7, Bill_8, Bill_9, Bill_10, Bill_11, Bill_12, and Bill_Total.
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
