logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Cooper EllissFinance
(5/5)

528 Answers

Hire Me
expert
James BeckettBusiness
(5/5)

730 Answers

Hire Me
expert
Connor EvanssEconomics
(5/5)

633 Answers

Hire Me
expert
Hunter EdwardsEnglish
(5/5)

899 Answers

Hire Me
SAS
(5/5)

You must complete the assignment by yourself. Exchanging ideas with classmates is encouraged

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

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.

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

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

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

298 Experts Online