Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have Date filed like below mentioned format
Date:
1.75 (1 year 7 months)
3.50 (3year 5 month)
9.25
10.50
11.00
I need output like below based on above data
0 -1 years
1 - 2 years
2- 3 years
3 -4 years
......
Please help me how to get this
Regards,
Siva
As below
temp:
Load interval_yy,replace(class(interval_yy,1),'<= x <','-')&' years' as group inline [
interval_yy
1.75
3.5
9.25
10.5
11
]
;
As below
temp:
Load interval_yy,replace(class(interval_yy,1),'<= x <','-')&' years' as group inline [
interval_yy
1.75
3.5
9.25
10.5
11
]
;