About numeric to character conversion in expressions of calculated item

[SilinBorro]

HI!

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.

Silvia

[arodriguez]

Hi,

I don't use Visual analitics, but in SAS, to change the format you use something like

put(id_project, best8.);

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.

[SilinBorro]

Hi!,

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.

thanks.

Silvia

[TejaSurapaneni]

Hi Sillin Borro,

Instead of that use Best Format.

Thanks & Regards,

Teja Surapaneni.

[VivekRathod]

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

My case:

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.'))

Thanks

Madhusudhan

SAS Administrator 

Landmark Group