BookmarkSubscribeRSS Feed
SilinBorro
Quartz | Level 8

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

 

4 REPLIES 4
arodriguez
Lapis Lazuli | Level 10

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
Quartz | Level 8

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
Lapis Lazuli | Level 10

Hi Sillin Borro,

 

Instead of that use Best Format.

 

Untitled.png

 

Thanks & Regards,

Teja Surapaneni.

VivekRathod
Fluorite | Level 6

 

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

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 5787 views
  • 1 like
  • 4 in conversation