This scenario uses the
Cert.Temp18 data set. Write a SAS program to do the following:
-
Create a temporary SAS data set
that uses Cert.Temp18 and store the results as Work.Scenario7.
-
Format the Day variable so that
the date appears as 01JAN2018.
-
Use a function to create a variable
named Month that is equal to the numeric value of the month of the
Day variable. For example, if the month is January, Month=1, if the
month is February, Month=2, and so on.
-
Create a one-way frequency table
using the variable HighTemp.
-
Use PROC MEANS to calculate the
mean and standard deviation for the variables AvgHighTemp and AvgLowTemp
by the new Month variable.