topic Re: how to use proc sql convert datetime to year? in SAS Procedures

how to use proc sql convert datetime to year?

R_E — Tue, 19 Mar 2013 03:13:59 GMT

Any one can help?

I want to convert a datetime to a year using proc sql in sas Eg.

for example, convert any time between '01Apr2001:00:00:00'dt and '31Mar2002:00:00:00'dt into 2002

between '01Apr2002:00:00:00'dt and '31Mar2003:00:00:00'dt into 2003

............

Reeza — Tue, 19 Mar 2013 03:41:47 GMT

Assuming its Proc SQL and not SQL Pass-Through

Try year(datepart(variable)))

LinusH — Tue, 19 Mar 2013 09:29:29 GMT

See my answer in this thread:

An alternative would be to create a user defined format.

R_E — Tue, 19 Mar 2013 22:45:18 GMT

I wrote a proc format code , but it come out with error message

here is the log attached.

but I still dont know how to correct it.Can you help me please.

I got one answer for initial question

year(intnx('year.4',datepart(time),1))

Thanks

R_E — Tue, 19 Mar 2013 23:01:20 GMT

Thanks, not exactly for my question

mfisher — Wed, 20 Mar 2013 15:36:52 GMT

March 31 is always 275 days until the end of the calendar year (even during leap year), so this works:

fiscal_year=year(datepart(intnx('dtday', datetime_var,275)));

Reeza — Wed, 20 Mar 2013 16:19:01 GMT

year=(year(datepart(date))+1)-(month(datepart(date))<=3);

*example for dates, not date time;

data have;

do i='01Jan2012'd to '31Dec2013'd;

year=(year(i)+1)-(month(i)<=3);

output;

end;

format i date9.;

run;

R_E — Wed, 20 Mar 2013 20:25:14 GMT

Thanks Reeza!
Awsome answer, it worked well.

R_E — Wed, 20 Mar 2013 20:27:59 GMT

Thanks Mifisher, your answer works well. sorry I was not allowed to choose two correct answer.