topic Re: determining weekdays character variable in SAS Programming

determining weekdays character variable

archibald — Wed, 18 May 2016 04:17:19 GMT

I have a character variable internship_date in the following format (20000130) and would like to get the week days?

Any ideas? Thanks

Kurt_Bremser — Wed, 18 May 2016 05:50:32 GMT

First, convert the character variable to a SAS date:

internship_date_d = input(internship_date,yymmdd8.);

Then, either use the weekday() function to obtain a number (0..6) that identifies the weekday, or use the weekday. format to display teh same number.

Or use the downame. format to display the English names of the weekdays.

archibald — Thu, 19 May 2016 01:10:17 GMT

You saved the day! thank you very much!