Answered step by step
Verified Expert Solution
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,
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 statementStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started