DATA Step, Macro, Functions and more

function to test for missing user-defined format

Reply
Contributor
Posts: 53

function to test for missing user-defined format

Is there a function to test for a missing user-defined format? I create a great deal of user-defined formats and am not always notifed by end-users that a new format needs to be created.
Super Contributor
Super Contributor
Posts: 3,174

Re: function to test for missing user-defined format

You can use DICTIONARY.FORMATS or SASHELP.VFORMAT to determine if a FORMAT/FORMATC member exists.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a001385596.htm
PROC Star
Posts: 1,561

Re: function to test for missing user-defined format

I agree with Scott, list the formats you need by looking at what tables use, then list the formats you have by looking at what your format catalogs contain, and compare.
Super Contributor
Super Contributor
Posts: 3,174

Re: function to test for missing user-defined format

And, if you want to test for a user-defined format using a function call, you can always use the EXIST function, knowing the libref and catalog, as well as format-type (either FORMAT or FORMATC).

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 3 replies
  • 118 views
  • 0 likes
  • 3 in conversation