## Converting integer to character

Occasional Contributor
Posts: 16

# Converting integer to character

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

Regular Contributor
Posts: 208

## Re: Converting integer to character

Hi Sanjeev..

Thanks & Regards,

Teja Surapaneni

Occasional Contributor
Posts: 16

## Re: Converting integer to character

Hi Teja,

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

Thank you,

Sanjeev

Regular Contributor
Posts: 208

## Re: Converting integer to character

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.

Occasional Contributor
Posts: 16

## Re: Converting integer to character

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

Regular Contributor
Posts: 208

## Re: Converting integer to character

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

Occasional Contributor
Posts: 16