Run the program below, which creates “Dates” in the HW library. You will need to change the input statement to account for the format of the raw data. Add the following to this data step: Using the yrdif function to add a variable called “Agetoday”, which is the age today.Use proc print to list all the variables to the output window.Remember to format all dates for output purposes.data HW.dates; input Subj $ DOB ;datalines;001 11Nov06002 25May07003 25Dec06;run;proc;run;

Start.Define a SAS dataset named "HW.dates."Specify two variables: "Subj" (character) and "DOB"…

Answered: Run the program below, which creates…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Run the program below, which creates “Dates” in the HW library. You will need to change the input statement to account for the format of the raw data. Add the following to this data step:
Using the yrdif function to add a variable called “Agetoday”, which is the age today.
Use proc print to list all the variables to the output window.
Remember to format all dates for output purposes.

data HW.dates;

input Subj $ DOB ;

datalines;

001 11Nov06

002 25May07

003 25Dec06

;

run;

proc;

run;

Expert Solution

Step 1: Algorithm:

Start.
Define a SAS dataset named "HW.dates."
Specify two variables: "Subj" (character) and "DOB" (date) with a specified date format of ddmmyy10.
Calculate the age today for each record using the yrdif function, storing the result in the "Agetoday" variable.
Format the "DOB" variable as date9. and the "Agetoday" variable as 6.2 for output purposes.
Input data for three records containing "Subj" and "DOB."
Use the "proc print" procedure to display all variables in the "HW.dates" dataset in the output window.
End.

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions