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

Different data formats in one column

Reply
Contributor
Posts: 25

Different data formats in one column

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!

Super User
Posts: 6,935

Re: Different data formats in one column

Posted in reply to gauravp1993

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).

Super User
Posts: 4,030

Re: Different data formats in one column

Posted in reply to gauravp1993

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.

Ask a Question
Discussion stats
  • 2 replies
  • 129 views
  • 0 likes
  • 3 in conversation