06-28-2016 01:37 PM
In my source file I have two numeric items that must be concatenated.
So I tried to convert them to string before concatenating them.
I create a calculated item to convert one of the fields into character,:
I ask for a preview of the results of the expression but nothing is displayed
What am I doing wrong?
Thanks in advanced.
07-05-2016 02:45 AM
I don't use Visual analitics, but in SAS, to change the format you use something like
Indicating that id_project must be put in best8. The result of the put is a string with the content of id_project in the format that you requested in categorical.
07-05-2016 12:54 PM
thanks for the answer.
I' ve tried with put command, but it'sn recognized as a command
in an expression.in a calculated item in SAS Visual Analytics.
thas's why I uses FORMAT.
11-20-2017 06:04 AM
1. I had a data of 800gb, but the user has loaded it on lasr, and the column trdng_wk_end was having the values in number 20170112.
2. To create a date out of 20170112 kind of numbers follow the following.
2. create a new calculated item. I used the combination of functions.
mdy - outer shell
parse - first inner shell
substr - second inner shell
format - inner most inner shell
DateFromMDY(Parse(Substring(Format('TRDNG_WK_END_DT'n, 'BEST2.'), 5, 2), 'COMMA2.'), Parse(Substring(Format('TRDNG_WK_END_DT'n, 'BEST2.'), 7, 2), 'COMMA2.'),
Parse(Substring(Format('TRDNG_WK_END_DT'n, 'BEST4.'), 1, 4), 'COMMA4.'))