Convert SAS Date Variable to Numeric Variable

[mahler_ji]

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

[LinusH]

Use the corresponding function in the assignment statement.

[mahler_ji]

Please forgive me, but I don't know what that means?

[Tom · Accepted solution]

wday=weekday(nextdt);

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201173.htm

[mahler_ji]

Thank you so much @tom!!

John