Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide SAS Code The following txt file named 'subs.txt' has content as follows. Name, Day, Month, Year, Subscription_biweek John, ,11,2020,$40.0 Julie, 05,06,2019,$36.0 Tom, 06, 10,

image text in transcribed

Provide SAS Code

The following txt file named 'subs.txt' has content as follows. Name, Day, Month, Year, Subscription_biweek John, ,11,2020,$40.0 Julie, 05,06,2019,$36.0 Tom, 06, 10, 2021, \$45.0 The column names are: - Name: name of the member - Day/Month/Year: the date when the member's subscription begins - Subscription_biweek: the biweekly subscription fee of the member's membership Write SAS code to: - Read in the following txt file named 'subs.txt' placed at "D:\SAS" folder. - Create a new variable called 'date' which represents the start date of subscription by concatenating the day, month and year variables together. Use the 15 th if the day variable is missing. - Print the data without day, month or year variables. - Create a new variable called 'subTotal' to represent the total number of subscription fees paid by each member from the start of the membership to today (subscriptions are paid every two weeks after the start of the membership). Print the new data set. Hint: - There is no txt file to download in this question. You should assume that it is placed in the folder "D:lSAS". Do not use the dataline statement

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Building Database Driven Catalogs

Authors: Sherif Danish

1st Edition

0070153078, 978-0070153073

More Books

Students also viewed these Databases questions

Question

b. Where did they come from?

Answered: 1 week ago

Question

c. What were the reasons for their move? Did they come voluntarily?

Answered: 1 week ago

Question

5. How do economic situations affect intergroup relations?

Answered: 1 week ago