topic How to modify a user-defined format in SAS Enterprise Guide

How to modify a user-defined format

obertel — Fri, 23 Feb 2018 08:04:28 GMT

Hi Gurus

I'm working with user-defined format, and need to change a stored user-defined format $nykrpak.

It have been stored for some time ago and I don't have the documentation or sas program that created it in the first place.

Instead of creating a new format, I want to change the existing.

Please recommend how to view and maintain a stored user-defined format.

Thanks.

Ole

Re: How to modify a user-defined format

andreas_lds — Fri, 23 Feb 2018 08:16:56 GMT

Use proc format with cntlout -option to save the format definition to a dataset, than modify the dataset an use proc format with cntlin to update the format definition. Having a backup of the catalog is recommended.

proc format cntlout=work.format_def;
   select $nypark;
run;

/* update dataset work.format_def */

proc format cntlin=work.format_def;
run;