Exploring, modeling, 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: 142

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

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

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

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

Hi Sillin Borro,

 

Instead of that use Best Format.

 

Untitled.png

 

Thanks & Regards,

Teja Surapaneni.

Post a Question
Discussion Stats
  • 3 replies
  • 1310 views
  • 0 likes
  • 3 in conversation