Exploring, modeling, 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: 196

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

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: 196

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

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: 196

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

Okay, Thank you.

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