Hello All,
I have a pretty simple question that is really hanging me up. I am converting some SAS dates using the following code into weekday format (which just returns a number for the day of the week):
data mylib.twt6;
set mylib.twt1_4;
wday = nextdt;
format wday weekday1.;
run;
I am creating a new variable called wday from a full date variable (nextdt) and then converting into weekday format.
But the thing is, I want to be able to do things with that number (the 1-7 number that the weekday format has) such as find the average of the numbers, or sum them.
How can i get those numbers to change to numeric format?
Thanks,
John
Use the corresponding function in the assignment statement.
Please forgive me, but I don't know what that means?
Thank you so much @tom!!
John
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.