Adding formats to a SAS Catalog

I have what is below in my autoexec.
/**************** SAS Formats ***************/
libname sasfmts   "D:\Projects\A_Pro\formats";
Options FmtSearch=(SASFMTS.afp_f) ;
/**************** SAS Formats ***************/
This sets up the format catalog in D:\Projects\A_Pro\formats". The catalog in there is called afp_f.sas7bcat. This catalog was given to me so I didn't create any of the formats in there. There are about 100 different formats in that catalog. So now I created a simple new format in sas and now want to add it to the afp_f.sas7bcat catalog. How do I do that?

Appreciate any help;
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aloysius LowCommented:
perrysf25Author Commented:
I tried to delete the question you made comments on because i put work detail information i dont want in the question.
I revised the question and reposted. Hope you don't mind. I just want to be able to add a new format to an existing cataglog. How do I do that?
perrysf25Author Commented:
Ah ok I read the comment on the other post. I actually have been doing what you said after I create a new format. But the number of catalogs in my folder will become numerous as I create formats all the time for the work I do. Is the no way to just add a format to an existing catalog?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Aloysius LowCommented:
like i posted, you can't add to an existing catalog unless you have the original data that was used to produce the catalog in the first place.

rather, i suggest you create a new catalog that resides in the same library as the original catalogs, and either 1. use options fmtsearch=(SASFMTS) i.e. just the libname only or 2. add your new catalog into the fmtsearch option: options fmtsearch=(SASFMTS.afp_f, SASFMTS.[your new format catalog name]) ;

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
perrysf25Author Commented:
Ok got it. Thanks!
Aloysius LowCommented:
well anyway if you are going to be creating a lot of formats, it's good if you store the data somewhere so that you can continually add to that dataset and produce a format catalog based on that dataset. then in that case you won't be needing to create new catalogs each time you have a new format. hope this helps.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.