Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Converting integer to character

Reply
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..

Image - 2.pngIMAGE - 1.png

I hope this will help You,

Thanks & Regards,

Teja Surapaneni

Occasional Contributor
Posts: 16

Re: Converting integer to character

Posted in reply to TejaSurapaneni

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

1.png

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

Posted in reply to TejaSurapaneni

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.

2.png3.png

Thanks & Regards

Teja Surapaneni

Occasional Contributor
Posts: 16

Re: Converting integer to character

Posted in reply to TejaSurapaneni

Okay, Thank you.

Ask a Question
Discussion stats
  • 6 replies
  • 639 views
  • 3 likes
  • 2 in conversation