how to use proc sql convert datetime to year?

[R_E]

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]

Assuming its Proc SQL and not SQL Pass-Through

Try year(datepart(variable)))

[R_E]

Thanks, not exactly for my question

[LinusH]

See my answer in this thread:

https://communities.sas.com/thread/41166

An alternative would be to create a user defined format.

[R_E]

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  

[mfisher]

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 · Accepted solution]

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]

Thanks Reeza!
Awsome answer, it worked well.

[R_E]

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