Desktop productivity for business analysts and programmers

How to modify a user-defined format

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

How to modify a user-defined format

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


Accepted Solutions
Solution
‎02-26-2018 03:57 AM
Valued Guide
Posts: 629

Re: How to modify a user-defined format

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;

View solution in original post


All Replies
Solution
‎02-26-2018 03:57 AM
Valued Guide
Posts: 629

Re: How to modify a user-defined format

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 232 views
  • 3 likes
  • 2 in conversation