11-02-2014 01:46 PM
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):
wday = nextdt;
format wday weekday1.;
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?
Need further help from the community? Please ask a new question.