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
Hi Sanjeev..
I hope this will help You,
Thanks & Regards,
Teja Surapaneni
Hi Teja,
This might help but could you send me the code itself...? As opposed to the Visual view.
Thank you,
Sanjeev
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.
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
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
Okay, Thank you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.