topic Re: Convert SAS Date Variable to Numeric Variable in SAS Procedures

Convert SAS Date Variable to Numeric Variable

mahler_ji — Sun, 02 Nov 2014 18:46:09 GMT

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

Re: Convert SAS Date Variable to Numeric Variable

LinusH — Sun, 02 Nov 2014 19:34:25 GMT

Use the corresponding function in the assignment statement.

Re: Convert SAS Date Variable to Numeric Variable

mahler_ji — Sun, 02 Nov 2014 19:40:03 GMT

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

Re: Convert SAS Date Variable to Numeric Variable

Tom — Sun, 02 Nov 2014 20:19:13 GMT

wday=weekday(nextdt);

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

Re: Convert SAS Date Variable to Numeric Variable

mahler_ji — Sun, 02 Nov 2014 20:23:14 GMT

Thank you so much @tom!!

John