topic Re: Different data formats in one column in SAS Visual Analytics

Different data formats in one column

gauravp1993 — Wed, 28 Mar 2018 16:40:12 GMT

Hello everyone,

I was trying to convert one of our fact column, which contain two type of data (as per their meaning from dimension) into two format - one will contain commaw. format and other contain numw.d format. Is it possible to convert and store both of them in single column?

We have to send this data to VA report and display over there.

Thank you in advance!

Re: Different data formats in one column

Astounding — Wed, 28 Mar 2018 18:40:55 GMT

Speaking in generalities ...

You would need to define your "single column" as character, and convert the incoming values to character (using different formats depending on the dimension).

Re: Different data formats in one column

SASKiwi — Wed, 28 Mar 2018 19:20:53 GMT

Since you are loading this data into VA I would create a calculated measure in VA based on the original variable to get the second required format.