Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Accepted Solution Solved
Reply
Contributor
Posts: 26
Accepted Solution

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

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?

 


Accepted Solutions
Solution
‎08-15-2016 12:23 PM
SAS Super FREQ
Posts: 676

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

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

View solution in original post


All Replies
Solution
‎08-15-2016 12:23 PM
SAS Super FREQ
Posts: 676

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

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

Contributor
Posts: 26

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

Thanks for the suggestion

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 261 views
  • 1 like
  • 2 in conversation