topic Re: Dates to day of the week in SAS Programming

Dates to day of the week

Ddb300 — Wed, 17 Feb 2021 16:14:54 GMT

Is there a code for taking a column from a large data set which shows the date in standard format to show the date and the day of the week it is ?

simplistic preferred

Re: Dates to day of the week

PaigeMiller — Wed, 17 Feb 2021 16:20:28 GMT

You can apply the WEEKDATE format to the variable that contains the date (assuming it is truly a SAS date value, which is the number of days since 01JAN1960).

Re: Dates to day of the week

mklangley — Wed, 17 Feb 2021 16:25:33 GMT

Or here is another way, using the DOWNAME format, to get the day of the week (Sunday, Monday, etc.):

data example;
    format date date9.;
    format day_of_the_week downame.;
    date = "17Feb2021"d;
    day_of_the_week = date;
run;

Re: Dates to day of the week

Ddb300 — Wed, 17 Feb 2021 16:25:22 GMT

Will this show the date also or just the day of the week?

Re: Dates to day of the week

Reeza — Wed, 17 Feb 2021 16:28:18 GMT

What do you mean exactly? Do you want to see Wednesday February 17, 2021? Wednesday? Day 4 (sunday = day 1)?

Either way, you're likely looking for a format, depending on exactly what you want.

data demo;
date = "17Feb2021"d;
date1 = date;
date2 = date;
format date weekdate. date1 weekday. date2 date9.;
run;

proc print data=demo;run;

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=leforinforref&docsetTarget=n0p2fmevfgj470n17h4k9f27qjag.htm&locale=en

@Ddb300 wrote:
Is there a code for taking a column from a large data set which shows the date in standard format to show the date and the day of the week it is ?

simplistic preferred

Re: Dates to day of the week

ballardw — Wed, 17 Feb 2021 16:27:19 GMT

@Ddb300 wrote:
Will this show the date also or just the day of the week?

SAS Provides a bunch of formats. You can also create your own with Proc Format.

How about showing an example of what you want the result to look like so we do not have to guess what you want?

Re: Dates to day of the week

mklangley — Wed, 17 Feb 2021 16:27:22 GMT

If you're looking for the day of the week and the date combined in a single variable, see @PaigeMiller's answer above.