topic Re: How to exclude a specific year? in SAS Programming

How to exclude a specific year?

ybz12003 — Fri, 12 Jul 2019 16:58:10 GMT

Hello:

I would like to exclude the year 2009 in the variable 'DOB'. DOB is the format of ''mmddyy10.''

Please advice how to approach it. Thanks.

Re: How to exclude a specific year?

Reeza — Fri, 12 Jul 2019 17:01:56 GMT

You use YEAR() to get the YEAR() from a data component and then use the standard ne or eq or comparison desired. This assumes your variable is type=numeric and format is mmddyy10. If the type is character this does not apply.

Re: How to exclude a specific year?

ybz12003 — Fri, 12 Jul 2019 17:19:13 GMT

So, it should be

 data want; set have; DOB ne year'2009'; run;

Re: How to exclude a specific year?

Reeza — Fri, 12 Jul 2019 17:22:35 GMT

No, but I'm assuming you tried that and it didn't work already with errors in the log.

YEAR() is function, the parameter would be a date variable that would return the date and then you would check if that value is not 2009.

Re: How to exclude a specific year?

Reeza — Fri, 12 Jul 2019 17:23:50 GMT

I'm going to assume you're just having a bad day, because this is pretty basic and you should be able to do this IMO, from what you post on here.
This would remove all records where the year of the date of birth is 2009.

if year(dob) ne 2009;

Re: How to exclude a specific year?

PaigeMiller — Fri, 12 Jul 2019 17:28:40 GMT

The YEAR() function uses parenthesis, and there are no quotes around numbers, and of course the rest of your SAS code has to be correct syntax as well.

data want; 
set have;
if year(DOB) ne 2009; 
run;

But there's no real need to create a separate data set to do any analysis

proc means data=have(where=(year(dob) ne 2009));
...
run;

Re: How to exclude a specific year?

BrahmanandaRao — Sat, 13 Jul 2019 08:56:59 GMT

data dsn;
input dob;
cards;
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
;
run;
data want; 
set dsn;
if dob eq 2009 then delete  ; 
run;

Re: How to exclude a specific year?

PaigeMiller — Sat, 13 Jul 2019 11:03:23 GMT

@BrahmanandaRao wrote:

data dsn;
input dob;
cards;
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
;
run;
data want; 
set dsn;
if dob eq 2009 then delete  ; 
run;

Or even shorter

data want;
input dob;
if dob ne 2009 then output;
cards;
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
;
run;

Re: How to exclude a specific year?

ybz12003 — Fri, 19 Jul 2019 19:26:31 GMT

Thank you so much, PaigeMiller!