topic Re: Converting integer to character in SAS Visual Analytics

Converting integer to character

Sanjeev — Fri, 12 Jun 2015 20:11:44 GMT

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

Re: Converting integer to character

TejaSurapaneni — Mon, 15 Jun 2015 05:33:04 GMT

Hi Sanjeev..

I hope this will help You,

Thanks & Regards,

Teja Surapaneni

Re: Converting integer to character

Sanjeev — Mon, 15 Jun 2015 11:45:38 GMT

Hi Teja,

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

Thank you,

Sanjeev

Re: Converting integer to character

TejaSurapaneni — Mon, 15 Jun 2015 12:39:19 GMT

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.

Re: Converting integer to character

Sanjeev — Mon, 15 Jun 2015 13:36:28 GMT

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

Re: Converting integer to character

TejaSurapaneni — Tue, 16 Jun 2015 07:56:09 GMT

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

Re: Converting integer to character

Sanjeev — Tue, 16 Jun 2015 13:20:33 GMT

Okay, Thank you.