Proc Format - Other

mflore — Thu, 19 May 2011 15:36:19 GMT

I am trying to create a permanent format with the goal of changing how skipped values are displayed in Proc Print. The character variable "Reason" is currently coded as ".SK" for skipped values. I would like them to display as "Skipped" when printed. Here is my code:

proc format library = MyFmt;
value $ReasonFmt
'.SK' = 'Skipped';
run;

proc print data = Data1;
var Reason;
format Reason $ReasonFmt.;
run;

The problem is that non-skipped values (e.g. "No applicable insurance" and "Patient transferred care") get truncated to 3 characters (e.g. "No " and "Pat"). Is there a way to change the display of ".SK" while maintaining the way all other values are printed?

Thanks for your help.

Re: Proc Format - Other

ballardw — Thu, 19 May 2011 19:53:49 GMT

The default length of a format is the length of the longest formatted value.

You need to specify a DEFAULT= in the value statement:

value $ReasonFmt (default=15)

topic Proc Format - Other in SAS Procedures

Proc Format - Other

Re: Proc Format - Other