Help using Base SAS procedures

How do to delete a format in a permanent format library

Reply
Occasional Contributor
Posts: 6

How do to delete a format in a permanent format library

I am needing to delete a defunct format from our format library. How do I go about doing that?

Thank you for any advice/suggestions.
Valued Guide
Posts: 653

Re: How do to delete a format in a permanent format library

Posted in reply to merrittsas
Formats are stored as entries in SAS catalogs. Assuming you have write access to the catalog you can delete it interactively through the SAS explorer. The entry name will correspond to the name of the format. You can use the FMTSEARCH option to show you the locations of the format catalogs.

From batch you can utilize the CATALOG and DATASETS procedures.
Occasional Contributor
Posts: 6

Re: How do to delete a format in a permanent format library

Posted in reply to merrittsas
Great, it worked deleting it interactively. Thank you very much!
Occasional Contributor
Posts: 8

Re: How do to delete a format in a permanent format library

[ Edited ]
Posted in reply to merrittsas

To delete format "BFC_ENKOPING_MOST_RECENT_MONTH." from catalog "formats" in libname "formats":

 

 

PROC CATALOG CATALOG=formats.formats;
  DELETE BFC_ENKOPING_MOST_RECENT_MONTH.FORMAT;
QUIT;

NOTE: Deleting entry BFC_ENKOPING_MOST_RECENT_MONTH.FORMAT in catalog FORMATS.FORMATS. NOTE: PROCEDURE CATALOG used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

 

Ask a Question
Discussion stats
  • 3 replies
  • 713 views
  • 0 likes
  • 3 in conversation