topic Re: How do you isolate Month, Day, or Year from a Date? in SAS Programming

How do you isolate Month, Day, or Year from a Date?

ManitobaMoose — Fri, 08 Sep 2017 21:21:12 GMT

Hi,

I am trying to create a second data set which finds when the day of the VisitD variable is a monday or the year of the VisitD variable is 2002. I am using the Set function. I am learning from SAS by Example and the answers are not in the book. Could someone offer some assistance? Thanks.

Below is the original dat set from which I want to find which dates fall on a Monday or are in the year 2002, using SAS code.

Libname SASdata '/folders/myfolders/SASData' ;
Data SasData.HealthHosp ;
   Input PatID 3.
          DOB   mmddyy10.
          VisitD mmddyy10. ;
   format DOB VisitD mmddyy10. ;
Datalines ;
00112/25/19445/17/2000
00205/11/19668/4/2002
00308/03/20009/2/2003
;

Re: How do you isolate Month, Day, or Year from a Date?

PeterClemmensen — Sat, 09 Sep 2017 09:03:47 GMT

Like this?

Data HealthHosp ;
    Input PatID 3.
          DOB   mmddyy10.
          VisitD mmddyy10. ;
    format DOB VisitD mmddyy10. ;
Datalines ;
00112/25/19445/17/2000
00205/11/19668/4/2002
00308/03/20009/2/2003
;

data want;
   set HealthHosp;
   where weekday(VisitD)=2 | year(VisitD)=2002;
run;

Re: How do you isolate Month, Day, or Year from a Date?

novinosrin — Fri, 08 Sep 2017 21:32:51 GMT

data want;
set HealthHosp;
where strip(put(weekday(VisitD),weekdate9.))="Monday" or year(visitd)=2002;
run;

Re: How do you isolate Month, Day, or Year from a Date?

Reeza — Fri, 08 Sep 2017 21:47:47 GMT

YEAR/MONTH/DAY functions.

Re: How do you isolate Month, Day, or Year from a Date?

ManitobaMoose — Fri, 08 Sep 2017 22:02:41 GMT

Grat, thanks. One quick follow up: I thought for the Weekday function Sunday = 1 and Monday = 2? That is what the book says, but maybe that has changed since?

Thanks.

Re: How do you isolate Month, Day, or Year from a Date?

Astounding — Fri, 08 Sep 2017 22:15:31 GMT

Good set of tools, but notice ...

For Monday, the WEEKDAY function should return 2 not 1. Also note, if you are reading from the raw data, you can build in efficiency (not a consideration when you have only a few lines of raw data):

Data want ;
    Input @ 14 VisitD mmddyy10. @ ;
    if weekday(VisitD) = 2 or year(VisitD) = 2002;
    Input @ 1 PatID 3.
          DOB   mmddyy10. ;
    format DOB VisitD mmddyy10. ;
Datalines ;
00112/25/19445/17/2000
00205/11/19668/4/2002
00308/03/20009/2/2003
;

Re: How do you isolate Month, Day, or Year from a Date?

PeterClemmensen — Sat, 09 Sep 2017 09:04:25 GMT

@Astounding, Good Catch 🙂