Converting integer to character

[Sanjeev]

In a SAS VA calculation, how can one convert an integer field to character. 

Say for example I'd like to build a fiscal year off a given data. I have the integer  years 2013, 2014 and would like to concatenate them to be "2013-214"

I'm using SAS VA 7.1

[TejaSurapaneni]

Hi Sanjeev..

I hope this will help You,

Thanks & Regards,

Teja Surapaneni

[Sanjeev]

Hi Teja,

This might help but could you send me the code itself...? As opposed to the Visual view.

Thank you,

Sanjeev

[TejaSurapaneni]

Hello Sanjeev,

Here It is

You can also take dates instead of years.  financial year.  i.e.,  1st April'14 - 31st March'15 (2014-2015).

Thanks & Regards,

Teja Surapaneni.

[Sanjeev]

Hi Teja,

This does not help. I would like to dynamically create the fiscal year - not hard code the return values. 

Here's how I would like to write the code:

if Month(DatePart('PS_Record_DateEffective'n )) in (1,2,3)  Return

   ToChar(Year(DatePart('PS_Record_DateEffective'n ))-1) +'-'+ ToChar(Year(DatePart('PS_Record_DateEffective'n ))

else

   ToChar(Year(DatePart('PS_Record_DateEffective'n ))) + '-'+ToChar(Year(DatePart('PS_Record_DateEffective'n )+1)

I just need a replacement for the ToChar function

Sanjeev

[TejaSurapaneni]

Hi Sanjeev,

You can't create character fiscal year in sas va.

If you want alternative, you can refer below (hard coded).

Using this method u can calculate future fiscal years.

Thanks & Regards

Teja Surapaneni

[Sanjeev]

Okay, Thank you.