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

[User12]

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?

[BrunoMueller · Accepted solution]

Hi

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

[User12]

Thanks for the suggestion