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

Modify Predefined format

Reply
Frequent Contributor
Posts: 96

Modify Predefined format

Hi All,
Is their any way to change pre defined format ?
For eg: i want to change commaw.d format, which is by default giving value like this 123,456,000 but my client wants value like this 12,34,56,000 (in indian comma )

My problem is that i had tried to create picture format and imported this format in SAS VA, but in VA if we use any user-defined format than it will convert that variable to category, and we can not convert it to measure if we want to use user-defined format (in my case that format is indian comma format), so in category i can not do calculations on that variable with user-defined format, ao is their any other way to apply user-defined format in VA and can do calculations also.
Trusted Advisor
Posts: 1,114

Re: Modify Predefined format

Hi @Kalind_Patel,

 

No, I don't think you can change a SAS-supplied format. You can only create your own user-defined formats (where using the same name as a SAS-supplied format is not a good idea, see SAS Problem Note 18075), as you did already.

 

I'm not familiar with VA, but normally a format on a numeric variable should not prevent calculations. In any case it should be possible to perform the calculations before the format comes into play. The format could be assigned at a late stage, only for reporting purposes.

Frequent Contributor
Posts: 96

Re: Modify Predefined format

Thanks @freelancereinhard for your reply, actually i tried both ways, using same name of predefined format & using with another name,
But no luck !!
And about VA limitation which i am talking about, i am also surprised after i knew that VA is not allowing variable (which has user-defined format ) to calculate, in base sas and eg, i can easily do calculations on the same variae with same user-defined format.

Please see this link :
http://support.sas.com/kb/47/100.html

In this link under "Formats in SAS® Visual Analytics Designer" section, it is clearly mentioned that you can not convert that variable (user-define format enabled ) from category to measure, and even i can not do calculations before applying the format, it is not possible in my scenario.


Trusted Advisor
Posts: 1,114

Re: Modify Predefined format

If there was no other way, I would then

  1. leave that numeric variable X unformatted
  2. perform the calculations with it
  3. store the result of the calculation in a different variable Y
  4. apply the desired format for reporting to variable Y

But, again, I have never used VA. So, the above approach may be unusual.

Frequent Contributor
Posts: 96

Re: Modify Predefined format

Thanks @freelancereinhard for you advice,
But unfortunately it will not work in VA,
Because va will do live calculations,
Not like base sas, so it will not work,
But anyway i really appreciate your assistance to solve this issue, thank you very much.
Ask a Question
Discussion stats
  • 4 replies
  • 375 views
  • 2 likes
  • 2 in conversation