topic Re: SAS VA 7.3>> IS there a way to divide my date variable in SAS Visual Analytics

SAS VA 7.3>> IS there a way to divide my date variable

User12 — Mon, 15 Aug 2016 15:42:10 GMT

IS there a way to divide my date variable i just want it, i just want it to divide half yearly, its same like quaterly but i want only 2 parts for year. Is there a way to do that?

Re: SAS VA 7.3>> IS there a way to divide my date variable

BrunoMueller — Mon, 15 Aug 2016 16:12:31 GMT

Create a new calculated item using the following expression

IF ( Month('someDate'n) BetweenInclusive(1, 6) )
RETURN Concatenate(Format('someDate'n[Raw], 'YEAR4.'), 'H1')
ELSE Concatenate(Format('someDate'n[Raw], 'YEAR4.'), 'H2')

You need to adjust the expression for your date data item

Bruno

Re: SAS VA 7.3>> IS there a way to divide my date variable

User12 — Mon, 15 Aug 2016 16:14:18 GMT

Thanks for the suggestion