topic Re: Show weekday function result (1) as weekday (Sunday)? in SAS Procedures

Show weekday function result (1) as weekday (Sunday)?

mnew — Sat, 05 Feb 2011 20:16:00 GMT

Experts:

Another beginner question. Reviewing the weekday function this morning. What is the best way to convert the weekday function result to 'Sunday...' instead of showing 1-7? Every solution I came up with seemed to be too clumsy. One of them was simply a bad idea. I tried to format the weekday result in weekdate3. :-).

Thank you!

Re: Show weekday function result (1) as weekday (Sunday)?

Vasile01 — Sat, 05 Feb 2011 20:22:54 GMT

Hi,
I am not yet an expert on SAS. Try look on proc format.
Warm regards,
Vasile

Re: Show weekday function result (1) as weekday (Sunday)?

data_null__ — Sat, 05 Feb 2011 21:38:11 GMT

Did you try weekdate9.?

[pre]
6 data _null_;
7 do date = today() to today()+14;
8 put date weekdate9.;
9 end;
10 run;

Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
[/pre]

Re: Show weekday function result (1) as weekday (Sunday)?

mnew — Sun, 06 Feb 2011 05:12:20 GMT

Thanks to you both!
My question is not how to format a date value to show the weekday. I was hoping for a shortcut that convert the weekday function results (1-7) to Sun-Sat. Proc Format as Vasile suggested is definitely a solution.

Re: Show weekday function result (1) as weekday (Sunday)?

Peter_C — Sun, 06 Feb 2011 07:55:57 GMT

have you tried PUT as a function?
Weekday = PUT( date_var, weekdate3. );

Re: Show weekday function result (1) as weekday (Sunday)?

mnew — Sun, 06 Feb 2011 19:43:40 GMT

Great idea. This is the shortcut I was looking for. Thank you.