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

Display currency format in cross table report based on condition.

Accepted Solution Solved
Reply
Contributor
Posts: 26
Accepted Solution

Display currency format in cross table report based on condition.

[ Edited ]

Can we define format based on condition in Cross tabulate, For Example one column have some numeric value and based on condition I want to show Char value in cross tab report

Numeric value                   char format I want to display on report

1001                                    USD

1002                                    INR

1003                                    AED

1004                                    HKD

 

I hope you understand my query. I want to display currency type but I am not able to drop-drag the char column (value is USD,INR.. etc). So I want to use a numeric value and based on numeric value I want to display the currency type in cross report. 


Accepted Solutions
Solution
‎02-28-2016 05:55 AM
Super User
Posts: 1,202

Re: Display currency format in cross table report based on condition.

Hi There,

 

It would be possible to do this with some data preparation outside of SAS Visual Analytics using a SAS user defined format (picture format). This paper may give you some ideas http://www2.sas.com/proceedings/sugi31/243-31.pdf and the SAS documentation, http://support.sas.com/documentation/cdl/en/proc/68954/HTML/default/viewer.htm#p1xidhqypi0fnwn1if8op...

 

There have been a few discussions on using user-defined formats in SAS Visual Analytics in this community that you may also find useful at:

 

Kind Regards,

Michelle

P.S. It is best for people to reply to the thread so that others can learn from the response. You may want to remove your email address from your post.

View solution in original post


All Replies
Solution
‎02-28-2016 05:55 AM
Super User
Posts: 1,202

Re: Display currency format in cross table report based on condition.

Hi There,

 

It would be possible to do this with some data preparation outside of SAS Visual Analytics using a SAS user defined format (picture format). This paper may give you some ideas http://www2.sas.com/proceedings/sugi31/243-31.pdf and the SAS documentation, http://support.sas.com/documentation/cdl/en/proc/68954/HTML/default/viewer.htm#p1xidhqypi0fnwn1if8op...

 

There have been a few discussions on using user-defined formats in SAS Visual Analytics in this community that you may also find useful at:

 

Kind Regards,

Michelle

P.S. It is best for people to reply to the thread so that others can learn from the response. You may want to remove your email address from your post.

Contributor
Posts: 26

Re: Display currency format in cross table report based on condition.

Hi Michelle ,

I want to apologize for my mistake (Regarding my email Id) and thanks for your replay Smiley Happy . Please remove my E-mail id from my last post.

 

I had Post my query regarding Cross table report (Subject: - “can we use different column combination in hierarchy under cross tabulate report in SAS VA”) . I am still not able to resolve that part.

Could you please suggest me some workaround?

Super User
Posts: 1,202

Re: Display currency format in cross table report based on condition.

Hi,

 

I am unable to remove your email address, only you can (by editing your post) or a SAS community administrator.

 

With regards to displaying multiple formats in a cross table report, I suggest the use of a user-defined picture format as I mentioned earlier. SAS programming skills and data preparation would be needed outside of SAS Visual Analytics.

 

Kind Regards,

Michelle

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