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

About numeric to character conversion in expressions of calculated item

Reply
Frequent Contributor
Posts: 77

About numeric to character conversion in expressions of calculated item

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,:

Snap 2016-06-28 at 14.31.57.jpg

 

I ask for a preview of the results of the expression but nothing is displayed

Snap 2016-06-28 at 14.33.45.jpg

 

What am I doing wrong?  

 

Thanks in advanced.

 

Silvia

 

Frequent Contributor
Posts: 146

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

Posted in reply to SilinBorro

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.

 

 

Frequent Contributor
Posts: 77

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

Posted in reply to arodriguez

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

 

 

Regular Contributor
Posts: 208

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

Posted in reply to SilinBorro

Hi Sillin Borro,

 

Instead of that use Best Format.

 

Untitled.png

 

Thanks & Regards,

Teja Surapaneni.

New Contributor
Posts: 3

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

Posted in reply to TejaSurapaneni

 

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

 

 

Ask a Question
Discussion stats
  • 4 replies
  • 3347 views
  • 1 like
  • 4 in conversation