topic About numeric to character conversion in expressions of calculated item in SAS Visual Analytics

About numeric to character conversion in expressions of calculated item

SilinBorro — Tue, 28 Jun 2016 17:37:53 GMT

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

Re: About numeric to character conversion in expressions of calculated item

arodriguez — Tue, 05 Jul 2016 06:45:14 GMT

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.

Re: About numeric to character conversion in expressions of calculated item

TejaSurapaneni — Tue, 05 Jul 2016 08:31:06 GMT

Hi Sillin Borro,

Instead of that use Best Format.

Thanks & Regards,

Teja Surapaneni.

Re: About numeric to character conversion in expressions of calculated item

SilinBorro — Tue, 05 Jul 2016 16:54:38 GMT

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

Re: About numeric to character conversion in expressions of calculated item

VivekRathod — Mon, 20 Nov 2017 11:04:59 GMT

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