BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

I want to create a format for a computed field which will be user defined format so that i can use it directly through Any SAS Application like Infomap or EG.
I have done all the settings required to be done in SAS config file.

I just want to create a format which will be generic so that i can use in to display all reports.

For example;
proc format library=xyz;
value mtest .='0.00' other=[comma16.2];
run;

I want this format to be generic so that i can use it anywhere.
for example:
If i want comma13.2 then I dont want to create other formats.
The above format i wnat since if my report has null values then i want to display 0.00 right aligned.
So any solution for this.
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi,
This is really not the right forum to post questions about formats, especially since your question involves configuration issues for use with SAS Information Maps and EG and this implies that your formats are used in the SAS Enterprise Intelligence Platform and also involves BI Platform Administration configuration and possibly start up scripts or start up commands.

I do not understand what you mean, exactly, when you say "I want this format to be generic so that i can use it anywhere." That could mean a lot of setup if "anywhere" involves INSIDE and OUTSIDE the BI Platform. You seem to understand the general syntax of using the LIBRARY= option with PROC FORMAT -- but there may be more needed in the BI platform. This SUGI paper on using formats (in general) has some good examples on format nesting -- which is what you seem to be trying to accomplish: http://www2.sas.com/proceedings/sugi25/25/aa/25p002.pdf

Your best bet for help with this question, in my opinion, is to contact SAS Tech Support: http://support.sas.com/techsup/contact/index.html

cynthia
MohamedS
Obsidian | Level 7
Hi Sunil,

you can create your own formats in one format file and save this format with all your customized formats into the following path of your meta data path:

X:\SAS\SASSolutionsConfig\Lev1\SASMain\SASEnvironment\SASFormats

make sure that this format file has the name "formats.sas7bcat". then just restart your SAS services. by this way you can use your customized format from any of SAS products (EG, InfoMap, DI...).

wishing you goodluck

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 659 views
  • 0 likes
  • 3 in conversation