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
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.
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
Hi Sillin Borro,
Instead of that use Best Format.
Thanks & Regards,
Teja Surapaneni.
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.