determining weekdays character variable

[archibald]

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 · Accepted solution]

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]

You saved the day! thank you very much!