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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.