topic proc format can't create format catalog under libref using university edition in SAS Programming

proc format can't create format catalog under libref using university edition

KK_QQ — Thu, 29 Dec 2016 02:08:08 GMT

I used the below code to create permanent format using university edition, the log has no problem.

proc format library=orion.MyFmts cntlin=country;
run;

But I can't see the catalog create under the orion, I deleted the library=orion.MyFmts, it still doesn't create format catalog uner work.

I don't know whehter it's because of university editon. can anyone help? Thanks!

Re: proc format can't create format catalog under libref using university edition

Reeza — Thu, 29 Dec 2016 02:12:20 GMT

Library are single level so try including only Orion after library, not Orion.myfmt

See examples here

http://www.ats.ucla.edu/stat/sas/library/formats.htm

Re: proc format can't create format catalog under libref using university edition

Reeza — Thu, 29 Dec 2016 02:13:37 GMT

I'm also not sure SAS UE shows catalog, so check for the presence using PROC datasets.

Re: proc format can't create format catalog under libref using university edition

Tom — Thu, 29 Dec 2016 02:15:37 GMT

Are you sure your input control dataset is in the proper format for creating formats?

What happens if you just define you formats using a VALUE statement instead?

Re: proc format can't create format catalog under libref using university edition

KK_QQ — Thu, 29 Dec 2016 02:24:44 GMT

It's not working either if only including Orion. It suppose create format catalog.

Re: proc format can't create format catalog under libref using university edition

Reeza — Thu, 29 Dec 2016 02:36:22 GMT

What does not working mean?

Do you get errors? If so, post the log.

Re: proc format can't create format catalog under libref using university edition

Reeza — Thu, 29 Dec 2016 02:37:32 GMT

@Reeza wrote:

Library are single level so try including only Orion after library, not Orion.myfmt

See examples here

http://www.ats.ucla.edu/stat/sas/library/formats.htm

My bad, catalogs are referenced in the manner used, ie libname.catalog_name

Re: proc format can't create format catalog under libref using university edition

KK_QQ — Thu, 29 Dec 2016 02:43:25 GMT

Actually, it does create the format catalog, when using below code

proc format library=orion.MyFmts fmtlib;
select $country;
run;

you can see the results. And when you used the format, it works. But just can't show up under the liberary.

Re: proc format can't create format catalog under libref using university edition

Astounding — Thu, 29 Dec 2016 03:28:52 GMT

Format libraries use a default catalog name. You are overriding that by specifying the two-level name. When creating the format, just specify library=orion, instead of library=orion.MyFmts and that should put the new format into the default library.