Description

First-time Directions:
In addition to completing the tasks given below, all programming assignments should include the following elements. These will not be repeated on future assignments, unless changes are necessary.
• Your program must include clear and concise comments to explain the intent of your code. Keep in mind that comments are not just for you – they are also for your colleagues and clients. There are typically multiple ways to achieve the same result, so use brief comments to explain your reasoning.
• Finally, while I can’t require you to do the following – I strongly suggest you:
– Even after submission (or before, if you prefer) you should to experiment with the code. Each assignment will be asking you for a specific task, but that does not mean it requires mastery of a programming technique. Try changing variables, or formats, or programming the same output a different way and see how it affects your results. Then figure out why! As an example, I won’t ask you about the IB and PDV contents on every assignment, but you should always know what is present in them!

1. Download the data set provided with this assignment to a folder named PROG HW1
2. Create a library named “HW1” that points to the same location you downloaded the data set.
3. Notice there is a non-SAS data set included. Create a fileref for named “Bank” for this data set.
4. Read in the “bank” file twice in two separate data sets using the following specifications. Each data set should be created directly in your “HW1” library, so don’t create any temporary copies.
(a) Use only simple list input and name the data set “Bank SLI”. The data set should contain five variables: FNAME, LNAME, ACCT, BALANCE, RATE.
(b) Use only modified list input and name the data set “Bank MLI”. The data set should contain four variables: NAME, ACCT, BALANCE, RATE.
5. Update your code for “Bank SLI” to do the following:
• Create a single variable – NAME – that contains the values of FNAME and LNAME for each record
• Add permanent labels for each of the variables
• Create character versions of the interest rate using the PERCENT format
– Include a comment that explains why this format doesn’t produce the value you probably wanted!
• Create a character variable, AcctType, that contains the first character from ACCT.
• Create a numeric variable, AcctNum, that contains the numeric portion from ACCT.
6. Add permanent labels to “BANK MLI” by using PROC DATASETS.
7. Produce a report that shows the descriptor portion of each of the data sets created in this assignment.