topic Re: How do you extract or subset observations for a specific year from variable date time from a data set ? in SAS Programming

How do you extract or subset observations for a specific year from variable date time from a data set ?

momin — Sun, 17 Aug 2014 23:27:50 GMT

How do you extract or subset observations for a specific year from variable date time from a data set ?

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

stat_sas — Sun, 17 Aug 2014 23:46:00 GMT

data have;
input date anydtdtm.;
format date datetime20.;
cards;
28-05-2013:11:21:20
27-05-2013:15:22:26
27-05-2013:11:36:33
27-05-2013:11:14:55
28-05-2014:10:21:20
27-05-2014:14:22:26
27-05-2014:11:36:33
27-05-2014:17:14:55
27-05-2014:10:34:56
27-05-2014:19:03:48
27-05-2014:14:30:56
;
run;

data want;
set have;
if year(datepart(date))=2013;
run;

proc print data=want;
run;

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Tom — Mon, 18 Aug 2014 00:16:45 GMT

If you have SAS 9.2 or newer you can use the DTEXTYEAR() function.

DT for Date Time

EXT for Extract

There are also DAY , MONTH, and WEEKDAY versions.

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Patrick — Mon, 18 Aug 2014 00:50:49 GMT

Hi Tom

I can find DTEXTYEAR() as a supported function by Access engines - but I can't find the function as such documented under "functions" SAS(R) 9.4 Functions and CALL Routines: Reference, Third Edition

Do you know where I could find the documentation and why this one is not documented where one would expect it?

Thanks

Patrick

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

momin — Mon, 18 Aug 2014 01:38:45 GMT

Data A;

set Shareef.emp;

if year(datepart(date))=1982;

run;

This is not working.returns zero observations. I know for sure that there is year 1982 in the following format 23jan198200.00.00 and the name of the variable is hiredate.

Thanks for the help.

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Tom — Mon, 18 Aug 2014 01:52:52 GMT

Don't know. It is in the view SASHELP.VFUNC. Not sure if it requires SAS/Access to be licensed.

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

momin — Mon, 18 Aug 2014 01:56:16 GMT

Hi Tom,

Is that the way to do it?

Thanks

Mohammed

Data B;

set Shareef.emp;

dtextyear(1982);

run;

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Tom — Mon, 18 Aug 2014 02:36:36 GMT

To subset data you need to use a WHERE statement ( or possibly an IF statement). A WHERE statement requires an expression that can be evaluated to be true or false. So if the variable in your dataset that has date time values is named DT then you might do something like.

data want ;

set have ;

where year(datepart(DT)) = 1982;

run;

Or you could use other forms:

where dtextyear(DT) = 1982 ;

where '01JAN1982:00:00'dt <= DT < '01JAN1983:00:00'dt ;

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

momin — Mon, 18 Aug 2014 02:58:11 GMT

SORRY, BOTH WAYS DON'T WORK.

THANKS ANYWAYS

MOHAMMED

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

stat_sas — Mon, 18 Aug 2014 03:08:30 GMT

It will not work unless you replace date with hiredate

Data A;

set Shareef.emp;

if year(datepart(hiredate))=1982;

run;

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Patrick — Mon, 18 Aug 2014 03:30:25 GMT

What is not working? Post your code and log.

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

momin — Mon, 18 Aug 2014 03:39:58 GMT

No,doesn't work!

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Patrick — Mon, 18 Aug 2014 06:34:41 GMT

Post your SAS code and the SAS log which shows us what exactly is not working.

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

Tom — Mon, 18 Aug 2014 17:01:23 GMT

Are you sure that HIREDATE is not a string instead of a proper datetime value?

Or perhaps it has already been converted from datetime to date. If so then just use the YEAR() function.

Re: How do you extract or subset observations for a specific year from variable date time from a data set ?

momin — Mon, 18 Aug 2014 17:07:00 GMT

tried again.it worked.Thanks for everyone's help.Regards

Mohammed